In this project, I will attempt to predict whether, for any given parcel in Detroit with a building on it, whether a building on that parcel will be be targetted for demoltion. Potential predictors, downloaded from https://data.detroitmi.gov/, include citations relatated to the building, crime, and complaints concerning the building related to blight. The probject is currently at the data cleaning stage, and I may add some other data to the project. So far, I am using about 3GB of data.

library(tidyverse)
library(sf)
library(ggmap)
library(lwgeom)
#recorded violations associated with blight (e.g. unkempt properties)
blight_violations <- read_csv("./data/Blight_Violations_3_19_2018.csv", 
                              guess_max = 10^6)
Parsed with column specification:
cols(
  .default = col_character(),
  `Ticket ID` = col_integer(),
  `Violator ID` = col_integer(),
  `Violation Street Number` = col_integer(),
  `Hearing Time` = col_time(format = ""),
  `Violation Latitude` = col_double(),
  `Violation Longitude` = col_double()
)
See spec(...) for full column specifications.

|                                                                                                  |   0%
|                                                                                                  |   0%
|                                                                                                  |   0%
|                                                                                                  |   0%
|                                                                                          |   0%    1 MB
|                                                                                          |   0%    1 MB
|                                                                                          |   0%    1 MB
|                                                                                          |   0%    1 MB
|                                                                                          |   0%    1 MB
|                                                                                          |   0%    1 MB
|                                                                                          |   0%    1 MB
|                                                                                          |   1%    1 MB
|=                                                                                         |   1%    1 MB
|=                                                                                         |   1%    2 MB
|=                                                                                         |   1%    2 MB
|=                                                                                         |   1%    2 MB
|=                                                                                         |   1%    2 MB
|=                                                                                         |   1%    2 MB
|=                                                                                         |   1%    2 MB
|=                                                                                         |   1%    2 MB
|=                                                                                         |   1%    2 MB
|=                                                                                         |   1%    2 MB
|=                                                                                         |   1%    3 MB
|=                                                                                         |   1%    3 MB
|=                                                                                         |   1%    3 MB
|=                                                                                         |   1%    3 MB
|=                                                                                         |   2%    3 MB
|=                                                                                         |   2%    3 MB
|=                                                                                         |   2%    3 MB
|==                                                                                        |   2%    3 MB
|==                                                                                        |   2%    3 MB
|==                                                                                        |   2%    4 MB
|==                                                                                        |   2%    4 MB
|==                                                                                        |   2%    4 MB
|==                                                                                        |   2%    4 MB
|==                                                                                        |   2%    4 MB
|==                                                                                        |   2%    4 MB
|==                                                                                        |   2%    4 MB
|==                                                                                        |   2%    4 MB
|==                                                                                        |   2%    4 MB
|==                                                                                        |   2%    5 MB
|==                                                                                        |   3%    5 MB
|==                                                                                        |   3%    5 MB
|==                                                                                        |   3%    5 MB
|==                                                                                        |   3%    5 MB
|===                                                                                       |   3%    5 MB
|===                                                                                       |   3%    5 MB
|===                                                                                       |   3%    5 MB
|===                                                                                       |   3%    5 MB
|===                                                                                       |   3%    6 MB
|===                                                                                       |   3%    6 MB
|===                                                                                       |   3%    6 MB
|===                                                                                       |   3%    6 MB
|===                                                                                       |   3%    6 MB
|===                                                                                       |   3%    6 MB
|===                                                                                       |   3%    6 MB
|===                                                                                       |   4%    6 MB
|===                                                                                       |   4%    6 MB
|===                                                                                       |   4%    7 MB
|===                                                                                       |   4%    7 MB
|===                                                                                       |   4%    7 MB
|===                                                                                       |   4%    7 MB
|====                                                                                      |   4%    7 MB
|====                                                                                      |   4%    7 MB
|====                                                                                      |   4%    7 MB
|====                                                                                      |   4%    7 MB
|====                                                                                      |   4%    7 MB
|====                                                                                      |   4%    8 MB
|====                                                                                      |   4%    8 MB
|====                                                                                      |   4%    8 MB
|====                                                                                      |   4%    8 MB
|====                                                                                      |   5%    8 MB
|====                                                                                      |   5%    8 MB
|====                                                                                      |   5%    8 MB
|====                                                                                      |   5%    8 MB
|====                                                                                      |   5%    8 MB
|====                                                                                      |   5%    9 MB
|====                                                                                      |   5%    9 MB
|====                                                                                      |   5%    9 MB
|=====                                                                                     |   5%    9 MB
|=====                                                                                     |   5%    9 MB
|=====                                                                                     |   5%    9 MB
|=====                                                                                     |   5%    9 MB
|=====                                                                                     |   5%    9 MB
|=====                                                                                     |   5%    9 MB
|=====                                                                                     |   5%   10 MB
|=====                                                                                     |   6%   10 MB
|=====                                                                                     |   6%   10 MB
|=====                                                                                     |   6%   10 MB
|=====                                                                                     |   6%   10 MB
|=====                                                                                     |   6%   10 MB
|=====                                                                                     |   6%   10 MB
|=====                                                                                     |   6%   10 MB
|=====                                                                                     |   6%   11 MB
|=====                                                                                     |   6%   11 MB
|======                                                                                    |   6%   11 MB
|======                                                                                    |   6%   11 MB
|======                                                                                    |   6%   11 MB
|======                                                                                    |   6%   11 MB
|======                                                                                    |   6%   11 MB
|======                                                                                    |   6%   11 MB
|======                                                                                    |   6%   11 MB
|======                                                                                    |   7%   12 MB
|======                                                                                    |   7%   12 MB
|======                                                                                    |   7%   12 MB
|======                                                                                    |   7%   12 MB
|======                                                                                    |   7%   12 MB
|======                                                                                    |   7%   12 MB
|======                                                                                    |   7%   12 MB
|======                                                                                    |   7%   12 MB
|======                                                                                    |   7%   12 MB
|======                                                                                    |   7%   13 MB
|=======                                                                                   |   7%   13 MB
|=======                                                                                   |   7%   13 MB
|=======                                                                                   |   7%   13 MB
|=======                                                                                   |   7%   13 MB
|=======                                                                                   |   7%   13 MB
|=======                                                                                   |   8%   13 MB
|=======                                                                                   |   8%   13 MB
|=======                                                                                   |   8%   13 MB
|=======                                                                                   |   8%   14 MB
|=======                                                                                   |   8%   14 MB
|=======                                                                                   |   8%   14 MB
|=======                                                                                   |   8%   14 MB
|=======                                                                                   |   8%   14 MB
|=======                                                                                   |   8%   14 MB
|=======                                                                                   |   8%   14 MB
|=======                                                                                   |   8%   14 MB
|========                                                                                  |   8%   14 MB
|========                                                                                  |   8%   15 MB
|========                                                                                  |   8%   15 MB
|========                                                                                  |   9%   15 MB
|========                                                                                  |   9%   15 MB
|========                                                                                  |   9%   15 MB
|========                                                                                  |   9%   15 MB
|========                                                                                  |   9%   15 MB
|========                                                                                  |   9%   15 MB
|========                                                                                  |   9%   16 MB
|========                                                                                  |   9%   16 MB
|========                                                                                  |   9%   16 MB
|========                                                                                  |   9%   16 MB
|========                                                                                  |   9%   16 MB
|========                                                                                  |   9%   16 MB
|========                                                                                  |   9%   16 MB
|=========                                                                                 |   9%   16 MB
|=========                                                                                 |   9%   16 MB
|=========                                                                                 |  10%   17 MB
|=========                                                                                 |  10%   17 MB
|=========                                                                                 |  10%   17 MB
|=========                                                                                 |  10%   17 MB
|=========                                                                                 |  10%   17 MB
|=========                                                                                 |  10%   17 MB
|=========                                                                                 |  10%   17 MB
|=========                                                                                 |  10%   17 MB
|=========                                                                                 |  10%   17 MB
|=========                                                                                 |  10%   18 MB
|=========                                                                                 |  10%   18 MB
|=========                                                                                 |  10%   18 MB
|=========                                                                                 |  10%   18 MB
|=========                                                                                 |  10%   18 MB
|=========                                                                                 |  10%   18 MB
|==========                                                                                |  11%   18 MB
|==========                                                                                |  11%   18 MB
|==========                                                                                |  11%   18 MB
|==========                                                                                |  11%   19 MB
|==========                                                                                |  11%   19 MB
|==========                                                                                |  11%   19 MB
|==========                                                                                |  11%   19 MB
|==========                                                                                |  11%   19 MB
|==========                                                                                |  11%   19 MB
|==========                                                                                |  11%   19 MB
|==========                                                                                |  11%   19 MB
|==========                                                                                |  11%   19 MB
|==========                                                                                |  11%   20 MB
|==========                                                                                |  11%   20 MB
|==========                                                                                |  11%   20 MB
|==========                                                                                |  12%   20 MB
|==========                                                                                |  12%   20 MB
|===========                                                                               |  12%   20 MB
|===========                                                                               |  12%   20 MB
|===========                                                                               |  12%   20 MB
|===========                                                                               |  12%   20 MB
|===========                                                                               |  12%   21 MB
|===========                                                                               |  12%   21 MB
|===========                                                                               |  12%   21 MB
|===========                                                                               |  12%   21 MB
|===========                                                                               |  12%   21 MB
|===========                                                                               |  12%   21 MB
|===========                                                                               |  12%   21 MB
|===========                                                                               |  12%   21 MB
|===========                                                                               |  12%   21 MB
|===========                                                                               |  12%   22 MB
|===========                                                                               |  13%   22 MB
|===========                                                                               |  13%   22 MB
|===========                                                                               |  13%   22 MB
|============                                                                              |  13%   22 MB
|============                                                                              |  13%   22 MB
|============                                                                              |  13%   22 MB
|============                                                                              |  13%   22 MB
|============                                                                              |  13%   22 MB
|============                                                                              |  13%   23 MB
|============                                                                              |  13%   23 MB
|============                                                                              |  13%   23 MB
|============                                                                              |  13%   23 MB
|============                                                                              |  13%   23 MB
|============                                                                              |  13%   23 MB
|============                                                                              |  13%   23 MB
|============                                                                              |  14%   23 MB
|============                                                                              |  14%   23 MB
|============                                                                              |  14%   24 MB
|============                                                                              |  14%   24 MB
|============                                                                              |  14%   24 MB
|=============                                                                             |  14%   24 MB
|=============                                                                             |  14%   24 MB
|=============                                                                             |  14%   24 MB
|=============                                                                             |  14%   24 MB
|=============                                                                             |  14%   24 MB
|=============                                                                             |  14%   24 MB
|=============                                                                             |  14%   25 MB
|=============                                                                             |  14%   25 MB
|=============                                                                             |  14%   25 MB
|=============                                                                             |  14%   25 MB
|=============                                                                             |  14%   25 MB
|=============                                                                             |  15%   25 MB
|=============                                                                             |  15%   25 MB
|=============                                                                             |  15%   25 MB
|=============                                                                             |  15%   25 MB
|=============                                                                             |  15%   26 MB
|==============                                                                            |  15%   26 MB
|==============                                                                            |  15%   26 MB
|==============                                                                            |  15%   26 MB
|==============                                                                            |  15%   26 MB
|==============                                                                            |  15%   26 MB
|==============                                                                            |  15%   26 MB
|==============                                                                            |  15%   26 MB
|==============                                                                            |  15%   26 MB
|==============                                                                            |  15%   27 MB
|==============                                                                            |  15%   27 MB
|==============                                                                            |  16%   27 MB
|==============                                                                            |  16%   27 MB
|==============                                                                            |  16%   27 MB
|==============                                                                            |  16%   27 MB
|==============                                                                            |  16%   27 MB
|==============                                                                            |  16%   27 MB
|==============                                                                            |  16%   27 MB
|===============                                                                           |  16%   28 MB
|===============                                                                           |  16%   28 MB
|===============                                                                           |  16%   28 MB
|===============                                                                           |  16%   28 MB
|===============                                                                           |  16%   28 MB
|===============                                                                           |  16%   28 MB
|===============                                                                           |  16%   28 MB
|===============                                                                           |  16%   28 MB
|===============                                                                           |  17%   28 MB
|===============                                                                           |  17%   29 MB
|===============                                                                           |  17%   29 MB
|===============                                                                           |  17%   29 MB
|===============                                                                           |  17%   29 MB
|===============                                                                           |  17%   29 MB
|===============                                                                           |  17%   29 MB
|===============                                                                           |  17%   29 MB
|===============                                                                           |  17%   29 MB
|================                                                                          |  17%   29 MB
|================                                                                          |  17%   30 MB
|================                                                                          |  17%   30 MB
|================                                                                          |  17%   30 MB
|================                                                                          |  17%   30 MB
|================                                                                          |  17%   30 MB
|================                                                                          |  17%   30 MB
|================                                                                          |  18%   30 MB
|================                                                                          |  18%   30 MB
|================                                                                          |  18%   30 MB
|================                                                                          |  18%   31 MB
|================                                                                          |  18%   31 MB
|================                                                                          |  18%   31 MB
|================                                                                          |  18%   31 MB
|================                                                                          |  18%   31 MB
|================                                                                          |  18%   31 MB
|================                                                                          |  18%   31 MB
|=================                                                                         |  18%   31 MB
|=================                                                                         |  18%   31 MB
|=================                                                                         |  18%   32 MB
|=================                                                                         |  18%   32 MB
|=================                                                                         |  18%   32 MB
|=================                                                                         |  19%   32 MB
|=================                                                                         |  19%   32 MB
|=================                                                                         |  19%   32 MB
|=================                                                                         |  19%   32 MB
|=================                                                                         |  19%   32 MB
|=================                                                                         |  19%   32 MB
|=================                                                                         |  19%   33 MB
|=================                                                                         |  19%   33 MB
|=================                                                                         |  19%   33 MB
|=================                                                                         |  19%   33 MB
|=================                                                                         |  19%   33 MB
|=================                                                                         |  19%   33 MB
|==================                                                                        |  19%   33 MB
|==================                                                                        |  19%   33 MB
|==================                                                                        |  19%   33 MB
|==================                                                                        |  19%   33 MB
|==================                                                                        |  20%   34 MB
|==================                                                                        |  20%   34 MB
|==================                                                                        |  20%   34 MB
|==================                                                                        |  20%   34 MB
|==================                                                                        |  20%   34 MB
|==================                                                                        |  20%   34 MB
|==================                                                                        |  20%   34 MB
|==================                                                                        |  20%   34 MB
|==================                                                                        |  20%   34 MB
|==================                                                                        |  20%   35 MB
|==================                                                                        |  20%   35 MB
|==================                                                                        |  20%   35 MB
|==================                                                                        |  20%   35 MB
|===================                                                                       |  20%   35 MB
|===================                                                                       |  20%   35 MB
|===================                                                                       |  21%   35 MB
|===================                                                                       |  21%   35 MB
|===================                                                                       |  21%   35 MB
|===================                                                                       |  21%   36 MB
|===================                                                                       |  21%   36 MB
|===================                                                                       |  21%   36 MB
|===================                                                                       |  21%   36 MB
|===================                                                                       |  21%   36 MB
|===================                                                                       |  21%   36 MB
|===================                                                                       |  21%   36 MB
|===================                                                                       |  21%   36 MB
|===================                                                                       |  21%   36 MB
|===================                                                                       |  21%   37 MB
|===================                                                                       |  21%   37 MB
|===================                                                                       |  21%   37 MB
|====================                                                                      |  22%   37 MB
|====================                                                                      |  22%   37 MB
|====================                                                                      |  22%   37 MB
|====================                                                                      |  22%   37 MB
|====================                                                                      |  22%   37 MB
|====================                                                                      |  22%   37 MB
|====================                                                                      |  22%   38 MB
|====================                                                                      |  22%   38 MB
|====================                                                                      |  22%   38 MB
|====================                                                                      |  22%   38 MB
|====================                                                                      |  22%   38 MB
|====================                                                                      |  22%   38 MB
|====================                                                                      |  22%   38 MB
|====================                                                                      |  22%   38 MB
|====================                                                                      |  22%   38 MB
|====================                                                                      |  22%   39 MB
|====================                                                                      |  23%   39 MB
|=====================                                                                     |  23%   39 MB
|=====================                                                                     |  23%   39 MB
|=====================                                                                     |  23%   39 MB
|=====================                                                                     |  23%   39 MB
|=====================                                                                     |  23%   39 MB
|=====================                                                                     |  23%   39 MB
|=====================                                                                     |  23%   39 MB
|=====================                                                                     |  23%   40 MB
|=====================                                                                     |  23%   40 MB
|=====================                                                                     |  23%   40 MB
|=====================                                                                     |  23%   40 MB
|=====================                                                                     |  23%   40 MB
|=====================                                                                     |  23%   40 MB
|=====================                                                                     |  23%   40 MB
|=====================                                                                     |  24%   40 MB
|=====================                                                                     |  24%   40 MB
|=====================                                                                     |  24%   41 MB
|======================                                                                    |  24%   41 MB
|======================                                                                    |  24%   41 MB
|======================                                                                    |  24%   41 MB
|======================                                                                    |  24%   41 MB
|======================                                                                    |  24%   41 MB
|======================                                                                    |  24%   41 MB
|======================                                                                    |  24%   41 MB
|======================                                                                    |  24%   41 MB
|======================                                                                    |  24%   42 MB
|======================                                                                    |  24%   42 MB
|======================                                                                    |  24%   42 MB
|======================                                                                    |  24%   42 MB
|======================                                                                    |  24%   42 MB
|======================                                                                    |  25%   42 MB
|======================                                                                    |  25%   42 MB
|======================                                                                    |  25%   42 MB
|======================                                                                    |  25%   42 MB
|=======================                                                                   |  25%   43 MB
|=======================                                                                   |  25%   43 MB
|=======================                                                                   |  25%   43 MB
|=======================                                                                   |  25%   43 MB
|=======================                                                                   |  25%   43 MB
|=======================                                                                   |  25%   43 MB
|=======================                                                                   |  25%   43 MB
|=======================                                                                   |  25%   43 MB
|=======================                                                                   |  25%   43 MB
|=======================                                                                   |  25%   44 MB
|=======================                                                                   |  25%   44 MB
|=======================                                                                   |  26%   44 MB
|=======================                                                                   |  26%   44 MB
|=======================                                                                   |  26%   44 MB
|=======================                                                                   |  26%   44 MB
|=======================                                                                   |  26%   44 MB
|=======================                                                                   |  26%   44 MB
|========================                                                                  |  26%   44 MB
|========================                                                                  |  26%   45 MB
|========================                                                                  |  26%   45 MB
|========================                                                                  |  26%   45 MB
|========================                                                                  |  26%   45 MB
|========================                                                                  |  26%   45 MB
|========================                                                                  |  26%   45 MB
|========================                                                                  |  26%   45 MB
|========================                                                                  |  26%   45 MB
|========================                                                                  |  26%   45 MB
|========================                                                                  |  27%   46 MB
|========================                                                                  |  27%   46 MB
|========================                                                                  |  27%   46 MB
|========================                                                                  |  27%   46 MB
|========================                                                                  |  27%   46 MB
|========================                                                                  |  27%   46 MB
|========================                                                                  |  27%   46 MB
|=========================                                                                 |  27%   46 MB
|=========================                                                                 |  27%   46 MB
|=========================                                                                 |  27%   47 MB
|=========================                                                                 |  27%   47 MB
|=========================                                                                 |  27%   47 MB
|=========================                                                                 |  27%   47 MB
|=========================                                                                 |  27%   47 MB
|=========================                                                                 |  27%   47 MB
|=========================                                                                 |  28%   47 MB
|=========================                                                                 |  28%   47 MB
|=========================                                                                 |  28%   47 MB
|=========================                                                                 |  28%   48 MB
|=========================                                                                 |  28%   48 MB
|=========================                                                                 |  28%   48 MB
|=========================                                                                 |  28%   48 MB
|=========================                                                                 |  28%   48 MB
|==========================                                                                |  28%   48 MB
|==========================                                                                |  28%   48 MB
|==========================                                                                |  28%   48 MB
|==========================                                                                |  28%   48 MB
|==========================                                                                |  28%   49 MB
|==========================                                                                |  28%   49 MB
|==========================                                                                |  28%   49 MB
|==========================                                                                |  29%   49 MB
|==========================                                                                |  29%   49 MB
|==========================                                                                |  29%   49 MB
|==========================                                                                |  29%   49 MB
|==========================                                                                |  29%   49 MB
|==========================                                                                |  29%   49 MB
|==========================                                                                |  29%   50 MB
|==========================                                                                |  29%   50 MB
|==========================                                                                |  29%   50 MB
|==========================                                                                |  29%   50 MB
|===========================                                                               |  29%   50 MB
|===========================                                                               |  29%   50 MB
|===========================                                                               |  29%   50 MB
|===========================                                                               |  29%   50 MB
|===========================                                                               |  29%   50 MB
|===========================                                                               |  30%   51 MB
|===========================                                                               |  30%   51 MB
|===========================                                                               |  30%   51 MB
|===========================                                                               |  30%   51 MB
|===========================                                                               |  30%   51 MB
|===========================                                                               |  30%   51 MB
|===========================                                                               |  30%   51 MB
|===========================                                                               |  30%   51 MB
|===========================                                                               |  30%   51 MB
|===========================                                                               |  30%   52 MB
|===========================                                                               |  30%   52 MB
|===========================                                                               |  30%   52 MB
|============================                                                              |  30%   52 MB
|============================                                                              |  30%   52 MB
|============================                                                              |  30%   52 MB
|============================                                                              |  31%   52 MB
|============================                                                              |  31%   52 MB
|============================                                                              |  31%   52 MB
|============================                                                              |  31%   53 MB
|============================                                                              |  31%   53 MB
|============================                                                              |  31%   53 MB
|============================                                                              |  31%   53 MB
|============================                                                              |  31%   53 MB
|============================                                                              |  31%   53 MB
|============================                                                              |  31%   53 MB
|============================                                                              |  31%   53 MB
|============================                                                              |  31%   53 MB
|============================                                                              |  31%   54 MB
|=============================                                                             |  31%   54 MB
|=============================                                                             |  31%   54 MB
|=============================                                                             |  32%   54 MB
|=============================                                                             |  32%   54 MB
|=============================                                                             |  32%   54 MB
|=============================                                                             |  32%   54 MB
|=============================                                                             |  32%   54 MB
|=============================                                                             |  32%   55 MB
|=============================                                                             |  32%   55 MB
|=============================                                                             |  32%   55 MB
|=============================                                                             |  32%   55 MB
|=============================                                                             |  32%   55 MB
|=============================                                                             |  32%   55 MB
|=============================                                                             |  32%   55 MB
|=============================                                                             |  32%   55 MB
|=============================                                                             |  32%   55 MB
|=============================                                                             |  32%   56 MB
|==============================                                                            |  33%   56 MB
|==============================                                                            |  33%   56 MB
|==============================                                                            |  33%   56 MB
|==============================                                                            |  33%   56 MB
|==============================                                                            |  33%   56 MB
|==============================                                                            |  33%   56 MB
|==============================                                                            |  33%   56 MB
|==============================                                                            |  33%   56 MB
|==============================                                                            |  33%   57 MB
|==============================                                                            |  33%   57 MB
|==============================                                                            |  33%   57 MB
|==============================                                                            |  33%   57 MB
|==============================                                                            |  33%   57 MB
|==============================                                                            |  33%   57 MB
|==============================                                                            |  33%   57 MB
|==============================                                                            |  34%   57 MB
|===============================                                                           |  34%   57 MB
|===============================                                                           |  34%   58 MB
|===============================                                                           |  34%   58 MB
|===============================                                                           |  34%   58 MB
|===============================                                                           |  34%   58 MB
|===============================                                                           |  34%   58 MB
|===============================                                                           |  34%   58 MB
|===============================                                                           |  34%   58 MB
|===============================                                                           |  34%   58 MB
|===============================                                                           |  34%   58 MB
|===============================                                                           |  34%   59 MB
|===============================                                                           |  34%   59 MB
|===============================                                                           |  34%   59 MB
|===============================                                                           |  34%   59 MB
|===============================                                                           |  35%   59 MB
|===============================                                                           |  35%   59 MB
|===============================                                                           |  35%   59 MB
|================================                                                          |  35%   59 MB
|================================                                                          |  35%   59 MB
|================================                                                          |  35%   60 MB
|================================                                                          |  35%   60 MB
|================================                                                          |  35%   60 MB
|================================                                                          |  35%   60 MB
|================================                                                          |  35%   60 MB
|================================                                                          |  35%   60 MB
|================================                                                          |  35%   60 MB
|================================                                                          |  35%   60 MB
|================================                                                          |  35%   60 MB
|================================                                                          |  35%   61 MB
|================================                                                          |  35%   61 MB
|================================                                                          |  36%   61 MB
|================================                                                          |  36%   61 MB
|================================                                                          |  36%   61 MB
|================================                                                          |  36%   61 MB
|=================================                                                         |  36%   61 MB
|=================================                                                         |  36%   61 MB
|=================================                                                         |  36%   61 MB
|=================================                                                         |  36%   62 MB
|=================================                                                         |  36%   62 MB
|=================================                                                         |  36%   62 MB
|=================================                                                         |  36%   62 MB
|=================================                                                         |  36%   62 MB
|=================================                                                         |  36%   62 MB
|=================================                                                         |  36%   62 MB
|=================================                                                         |  36%   62 MB
|=================================                                                         |  37%   62 MB
|=================================                                                         |  37%   63 MB
|=================================                                                         |  37%   63 MB
|=================================                                                         |  37%   63 MB
|=================================                                                         |  37%   63 MB
|==================================                                                        |  37%   63 MB
|==================================                                                        |  37%   63 MB
|==================================                                                        |  37%   63 MB
|==================================                                                        |  37%   63 MB
|==================================                                                        |  37%   63 MB
|==================================                                                        |  37%   64 MB
|==================================                                                        |  37%   64 MB
|==================================                                                        |  37%   64 MB
|==================================                                                        |  37%   64 MB
|==================================                                                        |  37%   64 MB
|==================================                                                        |  38%   64 MB
|==================================                                                        |  38%   64 MB
|==================================                                                        |  38%   64 MB
|==================================                                                        |  38%   64 MB
|==================================                                                        |  38%   65 MB
|==================================                                                        |  38%   65 MB
|==================================                                                        |  38%   65 MB
|===================================                                                       |  38%   65 MB
|===================================                                                       |  38%   65 MB
|===================================                                                       |  38%   65 MB
|===================================                                                       |  38%   65 MB
|===================================                                                       |  38%   65 MB
|===================================                                                       |  38%   66 MB
|===================================                                                       |  38%   66 MB
|===================================                                                       |  38%   66 MB
|===================================                                                       |  39%   66 MB
|===================================                                                       |  39%   66 MB
|===================================                                                       |  39%   66 MB
|===================================                                                       |  39%   66 MB
|===================================                                                       |  39%   66 MB
|===================================                                                       |  39%   66 MB
|===================================                                                       |  39%   67 MB
|===================================                                                       |  39%   67 MB
|===================================                                                       |  39%   67 MB
|====================================                                                      |  39%   67 MB
|====================================                                                      |  39%   67 MB
|====================================                                                      |  39%   67 MB
|====================================                                                      |  39%   67 MB
|====================================                                                      |  39%   67 MB
|====================================                                                      |  39%   67 MB
|====================================                                                      |  40%   68 MB
|====================================                                                      |  40%   68 MB
|====================================                                                      |  40%   68 MB
|====================================                                                      |  40%   68 MB
|====================================                                                      |  40%   68 MB
|====================================                                                      |  40%   68 MB
|====================================                                                      |  40%   68 MB
|====================================                                                      |  40%   68 MB
|====================================                                                      |  40%   68 MB
|====================================                                                      |  40%   69 MB
|=====================================                                                     |  40%   69 MB
|=====================================                                                     |  40%   69 MB
|=====================================                                                     |  40%   69 MB
|=====================================                                                     |  40%   69 MB
|=====================================                                                     |  40%   69 MB
|=====================================                                                     |  41%   69 MB
|=====================================                                                     |  41%   69 MB
|=====================================                                                     |  41%   69 MB
|=====================================                                                     |  41%   70 MB
|=====================================                                                     |  41%   70 MB
|=====================================                                                     |  41%   70 MB
|=====================================                                                     |  41%   70 MB
|=====================================                                                     |  41%   70 MB
|=====================================                                                     |  41%   70 MB
|=====================================                                                     |  41%   70 MB
|=====================================                                                     |  41%   70 MB
|=====================================                                                     |  41%   70 MB
|======================================                                                    |  41%   71 MB
|======================================                                                    |  41%   71 MB
|======================================                                                    |  41%   71 MB
|======================================                                                    |  41%   71 MB
|======================================                                                    |  42%   71 MB
|======================================                                                    |  42%   71 MB
|======================================                                                    |  42%   71 MB
|======================================                                                    |  42%   71 MB
|======================================                                                    |  42%   71 MB
|======================================                                                    |  42%   72 MB
|======================================                                                    |  42%   72 MB
|======================================                                                    |  42%   72 MB
|======================================                                                    |  42%   72 MB
|======================================                                                    |  42%   72 MB
|======================================                                                    |  42%   72 MB
|======================================                                                    |  42%   72 MB
|======================================                                                    |  42%   72 MB
|=======================================                                                   |  42%   72 MB
|=======================================                                                   |  42%   73 MB
|=======================================                                                   |  43%   73 MB
|=======================================                                                   |  43%   73 MB
|=======================================                                                   |  43%   73 MB
|=======================================                                                   |  43%   73 MB
|=======================================                                                   |  43%   73 MB
|=======================================                                                   |  43%   73 MB
|=======================================                                                   |  43%   73 MB
|=======================================                                                   |  43%   73 MB
|=======================================                                                   |  43%   74 MB
|=======================================                                                   |  43%   74 MB
|=======================================                                                   |  43%   74 MB
|=======================================                                                   |  43%   74 MB
|=======================================                                                   |  43%   74 MB
|=======================================                                                   |  43%   74 MB
|========================================                                                  |  43%   74 MB
|========================================                                                  |  44%   74 MB
|========================================                                                  |  44%   74 MB
|========================================                                                  |  44%   75 MB
|========================================                                                  |  44%   75 MB
|========================================                                                  |  44%   75 MB
|========================================                                                  |  44%   75 MB
|========================================                                                  |  44%   75 MB
|========================================                                                  |  44%   75 MB
|========================================                                                  |  44%   75 MB
|========================================                                                  |  44%   75 MB
|========================================                                                  |  44%   75 MB
|========================================                                                  |  44%   76 MB
|========================================                                                  |  44%   76 MB
|========================================                                                  |  44%   76 MB
|========================================                                                  |  44%   76 MB
|========================================                                                  |  45%   76 MB
|=========================================                                                 |  45%   76 MB
|=========================================                                                 |  45%   76 MB
|=========================================                                                 |  45%   76 MB
|=========================================                                                 |  45%   76 MB
|=========================================                                                 |  45%   77 MB
|=========================================                                                 |  45%   77 MB
|=========================================                                                 |  45%   77 MB
|=========================================                                                 |  45%   77 MB
|=========================================                                                 |  45%   77 MB
|=========================================                                                 |  45%   77 MB
|=========================================                                                 |  45%   77 MB
|=========================================                                                 |  45%   77 MB
|=========================================                                                 |  45%   77 MB
|=========================================                                                 |  45%   78 MB
|=========================================                                                 |  45%   78 MB
|=========================================                                                 |  46%   78 MB
|=========================================                                                 |  46%   78 MB
|==========================================                                                |  46%   78 MB
|==========================================                                                |  46%   78 MB
|==========================================                                                |  46%   78 MB
|==========================================                                                |  46%   78 MB
|==========================================                                                |  46%   78 MB
|==========================================                                                |  46%   79 MB
|==========================================                                                |  46%   79 MB
|==========================================                                                |  46%   79 MB
|==========================================                                                |  46%   79 MB
|==========================================                                                |  46%   79 MB
|==========================================                                                |  46%   79 MB
|==========================================                                                |  46%   79 MB
|==========================================                                                |  46%   79 MB
|==========================================                                                |  47%   80 MB
|==========================================                                                |  47%   80 MB
|==========================================                                                |  47%   80 MB
|===========================================                                               |  47%   80 MB
|===========================================                                               |  47%   80 MB
|===========================================                                               |  47%   80 MB
|===========================================                                               |  47%   80 MB
|===========================================                                               |  47%   80 MB
|===========================================                                               |  47%   80 MB
|===========================================                                               |  47%   81 MB
|===========================================                                               |  47%   81 MB
|===========================================                                               |  47%   81 MB
|===========================================                                               |  47%   81 MB
|===========================================                                               |  47%   81 MB
|===========================================                                               |  47%   81 MB
|===========================================                                               |  48%   81 MB
|===========================================                                               |  48%   81 MB
|===========================================                                               |  48%   81 MB
|===========================================                                               |  48%   82 MB
|===========================================                                               |  48%   82 MB
|============================================                                              |  48%   82 MB
|============================================                                              |  48%   82 MB
|============================================                                              |  48%   82 MB
|============================================                                              |  48%   82 MB
|============================================                                              |  48%   82 MB
|============================================                                              |  48%   82 MB
|============================================                                              |  48%   82 MB
|============================================                                              |  48%   83 MB
|============================================                                              |  48%   83 MB
|============================================                                              |  48%   83 MB
|============================================                                              |  49%   83 MB
|============================================                                              |  49%   83 MB
|============================================                                              |  49%   83 MB
|============================================                                              |  49%   83 MB
|============================================                                              |  49%   83 MB
|============================================                                              |  49%   83 MB
|============================================                                              |  49%   84 MB
|=============================================                                             |  49%   84 MB
|=============================================                                             |  49%   84 MB
|=============================================                                             |  49%   84 MB
|=============================================                                             |  49%   84 MB
|=============================================                                             |  49%   84 MB
|=============================================                                             |  49%   84 MB
|=============================================                                             |  49%   84 MB
|=============================================                                             |  49%   84 MB
|=============================================                                             |  50%   85 MB
|=============================================                                             |  50%   85 MB
|=============================================                                             |  50%   85 MB
|=============================================                                             |  50%   85 MB
|=============================================                                             |  50%   85 MB
|=============================================                                             |  50%   85 MB
|=============================================                                             |  50%   85 MB
|=============================================                                             |  50%   85 MB
|==============================================                                            |  50%   85 MB
|==============================================                                            |  50%   86 MB
|==============================================                                            |  50%   86 MB
|==============================================                                            |  50%   86 MB
|==============================================                                            |  50%   86 MB
|==============================================                                            |  50%   86 MB
|==============================================                                            |  50%   86 MB
|==============================================                                            |  51%   86 MB
|==============================================                                            |  51%   86 MB
|==============================================                                            |  51%   87 MB
|==============================================                                            |  51%   87 MB
|==============================================                                            |  51%   87 MB
|==============================================                                            |  51%   87 MB
|==============================================                                            |  51%   87 MB
|==============================================                                            |  51%   87 MB
|==============================================                                            |  51%   87 MB
|===============================================                                           |  51%   87 MB
|===============================================                                           |  51%   87 MB
|===============================================                                           |  51%   88 MB
|===============================================                                           |  51%   88 MB
|===============================================                                           |  51%   88 MB
|===============================================                                           |  51%   88 MB
|===============================================                                           |  52%   88 MB
|===============================================                                           |  52%   88 MB
|===============================================                                           |  52%   88 MB
|===============================================                                           |  52%   88 MB
|===============================================                                           |  52%   88 MB
|===============================================                                           |  52%   89 MB
|===============================================                                           |  52%   89 MB
|===============================================                                           |  52%   89 MB
|===============================================                                           |  52%   89 MB
|===============================================                                           |  52%   89 MB
|===============================================                                           |  52%   89 MB
|================================================                                          |  52%   89 MB
|================================================                                          |  52%   89 MB
|================================================                                          |  52%   89 MB
|================================================                                          |  52%   90 MB
|================================================                                          |  53%   90 MB
|================================================                                          |  53%   90 MB
|================================================                                          |  53%   90 MB
|================================================                                          |  53%   90 MB
|================================================                                          |  53%   90 MB
|================================================                                          |  53%   90 MB
|================================================                                          |  53%   90 MB
|================================================                                          |  53%   91 MB
|================================================                                          |  53%   91 MB
|================================================                                          |  53%   91 MB
|================================================                                          |  53%   91 MB
|================================================                                          |  53%   91 MB
|=================================================                                         |  53%   91 MB
|=================================================                                         |  53%   91 MB
|=================================================                                         |  53%   91 MB
|=================================================                                         |  54%   91 MB
|=================================================                                         |  54%   92 MB
|=================================================                                         |  54%   92 MB
|=================================================                                         |  54%   92 MB
|=================================================                                         |  54%   92 MB
|=================================================                                         |  54%   92 MB
|=================================================                                         |  54%   92 MB
|=================================================                                         |  54%   92 MB
|=================================================                                         |  54%   92 MB
|=================================================                                         |  54%   92 MB
|=================================================                                         |  54%   93 MB
|=================================================                                         |  54%   93 MB
|=================================================                                         |  54%   93 MB
|=================================================                                         |  54%   93 MB
|==================================================                                        |  55%   93 MB
|==================================================                                        |  55%   93 MB
|==================================================                                        |  55%   93 MB
|==================================================                                        |  55%   93 MB
|==================================================                                        |  55%   93 MB
|==================================================                                        |  55%   94 MB
|==================================================                                        |  55%   94 MB
|==================================================                                        |  55%   94 MB
|==================================================                                        |  55%   94 MB
|==================================================                                        |  55%   94 MB
|==================================================                                        |  55%   94 MB
|==================================================                                        |  55%   94 MB
|==================================================                                        |  55%   94 MB
|==================================================                                        |  55%   94 MB
|==================================================                                        |  55%   95 MB
|==================================================                                        |  56%   95 MB
|===================================================                                       |  56%   95 MB
|===================================================                                       |  56%   95 MB
|===================================================                                       |  56%   95 MB
|===================================================                                       |  56%   95 MB
|===================================================                                       |  56%   95 MB
|===================================================                                       |  56%   95 MB
|===================================================                                       |  56%   96 MB
|===================================================                                       |  56%   96 MB
|===================================================                                       |  56%   96 MB
|===================================================                                       |  56%   96 MB
|===================================================                                       |  56%   96 MB
|===================================================                                       |  56%   96 MB
|===================================================                                       |  56%   96 MB
|===================================================                                       |  56%   96 MB
|===================================================                                       |  57%   96 MB
|===================================================                                       |  57%   97 MB
|====================================================                                      |  57%   97 MB
|====================================================                                      |  57%   97 MB
|====================================================                                      |  57%   97 MB
|====================================================                                      |  57%   97 MB
|====================================================                                      |  57%   97 MB
|====================================================                                      |  57%   97 MB
|====================================================                                      |  57%   97 MB
|====================================================                                      |  57%   97 MB
|====================================================                                      |  57%   98 MB
|====================================================                                      |  57%   98 MB
|====================================================                                      |  57%   98 MB
|====================================================                                      |  57%   98 MB
|====================================================                                      |  57%   98 MB
|====================================================                                      |  58%   98 MB
|====================================================                                      |  58%   98 MB
|====================================================                                      |  58%   98 MB
|====================================================                                      |  58%   98 MB
|=====================================================                                     |  58%   99 MB
|=====================================================                                     |  58%   99 MB
|=====================================================                                     |  58%   99 MB
|=====================================================                                     |  58%   99 MB
|=====================================================                                     |  58%   99 MB
|=====================================================                                     |  58%   99 MB
|=====================================================                                     |  58%   99 MB
|=====================================================                                     |  58%   99 MB
|=====================================================                                     |  58%  100 MB
|=====================================================                                     |  58%  100 MB
|=====================================================                                     |  58%  100 MB
|=====================================================                                     |  59%  100 MB
|=====================================================                                     |  59%  100 MB
|=====================================================                                     |  59%  100 MB
|=====================================================                                     |  59%  100 MB
|=====================================================                                     |  59%  100 MB
|======================================================                                    |  59%  100 MB
|======================================================                                    |  59%  101 MB
|======================================================                                    |  59%  101 MB
|======================================================                                    |  59%  101 MB
|======================================================                                    |  59%  101 MB
|======================================================                                    |  59%  101 MB
|======================================================                                    |  59%  101 MB
|======================================================                                    |  59%  101 MB
|======================================================                                    |  59%  101 MB
|======================================================                                    |  59%  101 MB
|======================================================                                    |  60%  102 MB
|======================================================                                    |  60%  102 MB
|======================================================                                    |  60%  102 MB
|======================================================                                    |  60%  102 MB
|======================================================                                    |  60%  102 MB
|======================================================                                    |  60%  102 MB
|======================================================                                    |  60%  102 MB
|=======================================================                                   |  60%  102 MB
|=======================================================                                   |  60%  102 MB
|=======================================================                                   |  60%  103 MB
|=======================================================                                   |  60%  103 MB
|=======================================================                                   |  60%  103 MB
|=======================================================                                   |  60%  103 MB
|=======================================================                                   |  60%  103 MB
|=======================================================                                   |  60%  103 MB
|=======================================================                                   |  61%  103 MB
|=======================================================                                   |  61%  103 MB
|=======================================================                                   |  61%  103 MB
|=======================================================                                   |  61%  104 MB
|=======================================================                                   |  61%  104 MB
|=======================================================                                   |  61%  104 MB
|=======================================================                                   |  61%  104 MB
|=======================================================                                   |  61%  104 MB
|========================================================                                  |  61%  104 MB
|========================================================                                  |  61%  104 MB
|========================================================                                  |  61%  104 MB
|========================================================                                  |  61%  105 MB
|========================================================                                  |  61%  105 MB
|========================================================                                  |  61%  105 MB
|========================================================                                  |  61%  105 MB
|========================================================                                  |  62%  105 MB
|========================================================                                  |  62%  105 MB
|========================================================                                  |  62%  105 MB
|========================================================                                  |  62%  105 MB
|========================================================                                  |  62%  105 MB
|========================================================                                  |  62%  106 MB
|========================================================                                  |  62%  106 MB
|========================================================                                  |  62%  106 MB
|========================================================                                  |  62%  106 MB
|=========================================================                                 |  62%  106 MB
|=========================================================                                 |  62%  106 MB
|=========================================================                                 |  62%  106 MB
|=========================================================                                 |  62%  106 MB
|=========================================================                                 |  62%  106 MB
|=========================================================                                 |  62%  107 MB
|=========================================================                                 |  63%  107 MB
|=========================================================                                 |  63%  107 MB
|=========================================================                                 |  63%  107 MB
|=========================================================                                 |  63%  107 MB
|=========================================================                                 |  63%  107 MB
|=========================================================                                 |  63%  107 MB
|=========================================================                                 |  63%  107 MB
|=========================================================                                 |  63%  108 MB
|=========================================================                                 |  63%  108 MB
|=========================================================                                 |  63%  108 MB
|=========================================================                                 |  63%  108 MB
|==========================================================                                |  63%  108 MB
|==========================================================                                |  63%  108 MB
|==========================================================                                |  63%  108 MB
|==========================================================                                |  63%  108 MB
|==========================================================                                |  64%  108 MB
|==========================================================                                |  64%  109 MB
|==========================================================                                |  64%  109 MB
|==========================================================                                |  64%  109 MB
|==========================================================                                |  64%  109 MB
|==========================================================                                |  64%  109 MB
|==========================================================                                |  64%  109 MB
|==========================================================                                |  64%  109 MB
|==========================================================                                |  64%  109 MB
|==========================================================                                |  64%  109 MB
|==========================================================                                |  64%  110 MB
|==========================================================                                |  64%  110 MB
|===========================================================                               |  64%  110 MB
|===========================================================                               |  64%  110 MB
|===========================================================                               |  65%  110 MB
|===========================================================                               |  65%  110 MB
|===========================================================                               |  65%  110 MB
|===========================================================                               |  65%  110 MB
|===========================================================                               |  65%  110 MB
|===========================================================                               |  65%  111 MB
|===========================================================                               |  65%  111 MB
|===========================================================                               |  65%  111 MB
|===========================================================                               |  65%  111 MB
|===========================================================                               |  65%  111 MB
|===========================================================                               |  65%  111 MB
|===========================================================                               |  65%  111 MB
|===========================================================                               |  65%  111 MB
|===========================================================                               |  65%  112 MB
|============================================================                              |  65%  112 MB
|============================================================                              |  66%  112 MB
|============================================================                              |  66%  112 MB
|============================================================                              |  66%  112 MB
|============================================================                              |  66%  112 MB
|============================================================                              |  66%  112 MB
|============================================================                              |  66%  112 MB
|============================================================                              |  66%  112 MB
|============================================================                              |  66%  113 MB
|============================================================                              |  66%  113 MB
|============================================================                              |  66%  113 MB
|============================================================                              |  66%  113 MB
|============================================================                              |  66%  113 MB
|============================================================                              |  66%  113 MB
|============================================================                              |  66%  113 MB
|============================================================                              |  66%  113 MB
|=============================================================                             |  67%  113 MB
|=============================================================                             |  67%  114 MB
|=============================================================                             |  67%  114 MB
|=============================================================                             |  67%  114 MB
|=============================================================                             |  67%  114 MB
|=============================================================                             |  67%  114 MB
|=============================================================                             |  67%  114 MB
|=============================================================                             |  67%  114 MB
|=============================================================                             |  67%  114 MB
|=============================================================                             |  67%  114 MB
|=============================================================                             |  67%  115 MB
|=============================================================                             |  67%  115 MB
|=============================================================                             |  67%  115 MB
|=============================================================                             |  67%  115 MB
|=============================================================                             |  67%  115 MB
|=============================================================                             |  68%  115 MB
|=============================================================                             |  68%  115 MB
|==============================================================                            |  68%  115 MB
|==============================================================                            |  68%  116 MB
|==============================================================                            |  68%  116 MB
|==============================================================                            |  68%  116 MB
|==============================================================                            |  68%  116 MB
|==============================================================                            |  68%  116 MB
|==============================================================                            |  68%  116 MB
|==============================================================                            |  68%  116 MB
|==============================================================                            |  68%  116 MB
|==============================================================                            |  68%  116 MB
|==============================================================                            |  68%  117 MB
|==============================================================                            |  68%  117 MB
|==============================================================                            |  68%  117 MB
|==============================================================                            |  69%  117 MB
|==============================================================                            |  69%  117 MB
|==============================================================                            |  69%  117 MB
|===============================================================                           |  69%  117 MB
|===============================================================                           |  69%  117 MB
|===============================================================                           |  69%  117 MB
|===============================================================                           |  69%  118 MB
|===============================================================                           |  69%  118 MB
|===============================================================                           |  69%  118 MB
|===============================================================                           |  69%  118 MB
|===============================================================                           |  69%  118 MB
|===============================================================                           |  69%  118 MB
|===============================================================                           |  69%  118 MB
|===============================================================                           |  69%  118 MB
|===============================================================                           |  69%  119 MB
|===============================================================                           |  70%  119 MB
|===============================================================                           |  70%  119 MB
|===============================================================                           |  70%  119 MB
|===============================================================                           |  70%  119 MB
|================================================================                          |  70%  119 MB
|================================================================                          |  70%  119 MB
|================================================================                          |  70%  119 MB
|================================================================                          |  70%  119 MB
|================================================================                          |  70%  120 MB
|================================================================                          |  70%  120 MB
|================================================================                          |  70%  120 MB
|================================================================                          |  70%  120 MB
|================================================================                          |  70%  120 MB
|================================================================                          |  70%  120 MB
|================================================================                          |  71%  120 MB
|================================================================                          |  71%  120 MB
|================================================================                          |  71%  120 MB
|================================================================                          |  71%  121 MB
|================================================================                          |  71%  121 MB
|================================================================                          |  71%  121 MB
|================================================================                          |  71%  121 MB
|=================================================================                         |  71%  121 MB
|=================================================================                         |  71%  121 MB
|=================================================================                         |  71%  121 MB
|=================================================================                         |  71%  121 MB
|=================================================================                         |  71%  121 MB
|=================================================================                         |  71%  122 MB
|=================================================================                         |  71%  122 MB
|=================================================================                         |  71%  122 MB
|=================================================================                         |  72%  122 MB
|=================================================================                         |  72%  122 MB
|=================================================================                         |  72%  122 MB
|=================================================================                         |  72%  122 MB
|=================================================================                         |  72%  122 MB
|=================================================================                         |  72%  123 MB
|=================================================================                         |  72%  123 MB
|=================================================================                         |  72%  123 MB
|==================================================================                        |  72%  123 MB
|==================================================================                        |  72%  123 MB
|==================================================================                        |  72%  123 MB
|==================================================================                        |  72%  123 MB
|==================================================================                        |  72%  123 MB
|==================================================================                        |  72%  123 MB
|==================================================================                        |  72%  124 MB
|==================================================================                        |  73%  124 MB
|==================================================================                        |  73%  124 MB
|==================================================================                        |  73%  124 MB
|==================================================================                        |  73%  124 MB
|==================================================================                        |  73%  124 MB
|==================================================================                        |  73%  124 MB
|==================================================================                        |  73%  124 MB
|==================================================================                        |  73%  124 MB
|==================================================================                        |  73%  125 MB
|===================================================================                       |  73%  125 MB
|===================================================================                       |  73%  125 MB
|===================================================================                       |  73%  125 MB
|===================================================================                       |  73%  125 MB
|===================================================================                       |  73%  125 MB
|===================================================================                       |  73%  125 MB
|===================================================================                       |  74%  125 MB
|===================================================================                       |  74%  126 MB
|===================================================================                       |  74%  126 MB
|===================================================================                       |  74%  126 MB
|===================================================================                       |  74%  126 MB
|===================================================================                       |  74%  126 MB
|===================================================================                       |  74%  126 MB
|===================================================================                       |  74%  126 MB
|===================================================================                       |  74%  126 MB
|===================================================================                       |  74%  126 MB
|===================================================================                       |  74%  127 MB
|====================================================================                      |  74%  127 MB
|====================================================================                      |  74%  127 MB
|====================================================================                      |  74%  127 MB
|====================================================================                      |  74%  127 MB
|====================================================================                      |  75%  127 MB
|====================================================================                      |  75%  127 MB
|====================================================================                      |  75%  127 MB
|====================================================================                      |  75%  127 MB
|====================================================================                      |  75%  128 MB
|====================================================================                      |  75%  128 MB
|====================================================================                      |  75%  128 MB
|====================================================================                      |  75%  128 MB
|====================================================================                      |  75%  128 MB
|====================================================================                      |  75%  128 MB
|====================================================================                      |  75%  128 MB
|====================================================================                      |  75%  128 MB
|=====================================================================                     |  75%  128 MB
|=====================================================================                     |  75%  129 MB
|=====================================================================                     |  76%  129 MB
|=====================================================================                     |  76%  129 MB
|=====================================================================                     |  76%  129 MB
|=====================================================================                     |  76%  129 MB
|=====================================================================                     |  76%  129 MB
|=====================================================================                     |  76%  129 MB
|=====================================================================                     |  76%  129 MB
|=====================================================================                     |  76%  130 MB
|=====================================================================                     |  76%  130 MB
|=====================================================================                     |  76%  130 MB
|=====================================================================                     |  76%  130 MB
|=====================================================================                     |  76%  130 MB
|=====================================================================                     |  76%  130 MB
|=====================================================================                     |  76%  130 MB
|======================================================================                    |  76%  130 MB
|======================================================================                    |  77%  130 MB
|======================================================================                    |  77%  131 MB
|======================================================================                    |  77%  131 MB
|======================================================================                    |  77%  131 MB
|======================================================================                    |  77%  131 MB
|======================================================================                    |  77%  131 MB
|======================================================================                    |  77%  131 MB
|======================================================================                    |  77%  131 MB
|======================================================================                    |  77%  131 MB
|======================================================================                    |  77%  131 MB
|======================================================================                    |  77%  132 MB
|======================================================================                    |  77%  132 MB
|======================================================================                    |  77%  132 MB
|======================================================================                    |  77%  132 MB
|======================================================================                    |  77%  132 MB
|=======================================================================                   |  78%  132 MB
|=======================================================================                   |  78%  132 MB
|=======================================================================                   |  78%  132 MB
|=======================================================================                   |  78%  133 MB
|=======================================================================                   |  78%  133 MB
|=======================================================================                   |  78%  133 MB
|=======================================================================                   |  78%  133 MB
|=======================================================================                   |  78%  133 MB
|=======================================================================                   |  78%  133 MB
|=======================================================================                   |  78%  133 MB
|=======================================================================                   |  78%  133 MB
|=======================================================================                   |  78%  133 MB
|=======================================================================                   |  78%  134 MB
|=======================================================================                   |  78%  134 MB
|=======================================================================                   |  78%  134 MB
|=======================================================================                   |  79%  134 MB
|=======================================================================                   |  79%  134 MB
|========================================================================                  |  79%  134 MB
|========================================================================                  |  79%  134 MB
|========================================================================                  |  79%  134 MB
|========================================================================                  |  79%  134 MB
|========================================================================                  |  79%  135 MB
|========================================================================                  |  79%  135 MB
|========================================================================                  |  79%  135 MB
|========================================================================                  |  79%  135 MB
|========================================================================                  |  79%  135 MB
|========================================================================                  |  79%  135 MB
|========================================================================                  |  79%  135 MB
|========================================================================                  |  79%  135 MB
|========================================================================                  |  79%  136 MB
|========================================================================                  |  80%  136 MB
|========================================================================                  |  80%  136 MB
|========================================================================                  |  80%  136 MB
|=========================================================================                 |  80%  136 MB
|=========================================================================                 |  80%  136 MB
|=========================================================================                 |  80%  136 MB
|=========================================================================                 |  80%  136 MB
|=========================================================================                 |  80%  136 MB
|=========================================================================                 |  80%  137 MB
|=========================================================================                 |  80%  137 MB
|=========================================================================                 |  80%  137 MB
|=========================================================================                 |  80%  137 MB
|=========================================================================                 |  80%  137 MB
|=========================================================================                 |  80%  137 MB
|=========================================================================                 |  81%  137 MB
|=========================================================================                 |  81%  137 MB
|=========================================================================                 |  81%  137 MB
|=========================================================================                 |  81%  138 MB
|=========================================================================                 |  81%  138 MB
|==========================================================================                |  81%  138 MB
|==========================================================================                |  81%  138 MB
|==========================================================================                |  81%  138 MB
|==========================================================================                |  81%  138 MB
|==========================================================================                |  81%  138 MB
|==========================================================================                |  81%  138 MB
|==========================================================================                |  81%  138 MB
|==========================================================================                |  81%  139 MB
|==========================================================================                |  81%  139 MB
|==========================================================================                |  81%  139 MB
|==========================================================================                |  82%  139 MB
|==========================================================================                |  82%  139 MB
|==========================================================================                |  82%  139 MB
|==========================================================================                |  82%  139 MB
|==========================================================================                |  82%  139 MB
|==========================================================================                |  82%  140 MB
|===========================================================================               |  82%  140 MB
|===========================================================================               |  82%  140 MB
|===========================================================================               |  82%  140 MB
|===========================================================================               |  82%  140 MB
|===========================================================================               |  82%  140 MB
|===========================================================================               |  82%  140 MB
|===========================================================================               |  82%  140 MB
|===========================================================================               |  82%  140 MB
|===========================================================================               |  82%  141 MB
|===========================================================================               |  83%  141 MB
|===========================================================================               |  83%  141 MB
|===========================================================================               |  83%  141 MB
|===========================================================================               |  83%  141 MB
|===========================================================================               |  83%  141 MB
|===========================================================================               |  83%  141 MB
|===========================================================================               |  83%  141 MB
|===========================================================================               |  83%  141 MB
|============================================================================              |  83%  142 MB
|============================================================================              |  83%  142 MB
|============================================================================              |  83%  142 MB
|============================================================================              |  83%  142 MB
|============================================================================              |  83%  142 MB
|============================================================================              |  83%  142 MB
|============================================================================              |  83%  142 MB
|============================================================================              |  84%  142 MB
|============================================================================              |  84%  143 MB
|============================================================================              |  84%  143 MB
|============================================================================              |  84%  143 MB
|============================================================================              |  84%  143 MB
|============================================================================              |  84%  143 MB
|============================================================================              |  84%  143 MB
|============================================================================              |  84%  143 MB
|============================================================================              |  84%  143 MB
|=============================================================================             |  84%  143 MB
|=============================================================================             |  84%  144 MB
|=============================================================================             |  84%  144 MB
|=============================================================================             |  84%  144 MB
|=============================================================================             |  84%  144 MB
|=============================================================================             |  85%  144 MB
|=============================================================================             |  85%  144 MB
|=============================================================================             |  85%  144 MB
|=============================================================================             |  85%  144 MB
|=============================================================================             |  85%  144 MB
|=============================================================================             |  85%  145 MB
|=============================================================================             |  85%  145 MB
|=============================================================================             |  85%  145 MB
|=============================================================================             |  85%  145 MB
|=============================================================================             |  85%  145 MB
|=============================================================================             |  85%  145 MB
|==============================================================================            |  85%  145 MB
|==============================================================================            |  85%  145 MB
|==============================================================================            |  85%  145 MB
|==============================================================================            |  85%  146 MB
|==============================================================================            |  86%  146 MB
|==============================================================================            |  86%  146 MB
|==============================================================================            |  86%  146 MB
|==============================================================================            |  86%  146 MB
|==============================================================================            |  86%  146 MB
|==============================================================================            |  86%  146 MB
|==============================================================================            |  86%  146 MB
|==============================================================================            |  86%  147 MB
|==============================================================================            |  86%  147 MB
|==============================================================================            |  86%  147 MB
|==============================================================================            |  86%  147 MB
|==============================================================================            |  86%  147 MB
|===============================================================================           |  86%  147 MB
|===============================================================================           |  86%  147 MB
|===============================================================================           |  86%  147 MB
|===============================================================================           |  87%  147 MB
|===============================================================================           |  87%  148 MB
|===============================================================================           |  87%  148 MB
|===============================================================================           |  87%  148 MB
|===============================================================================           |  87%  148 MB
|===============================================================================           |  87%  148 MB
|===============================================================================           |  87%  148 MB
|===============================================================================           |  87%  148 MB
|===============================================================================           |  87%  148 MB
|===============================================================================           |  87%  149 MB
|===============================================================================           |  87%  149 MB
|===============================================================================           |  87%  149 MB
|===============================================================================           |  87%  149 MB
|===============================================================================           |  87%  149 MB
|================================================================================          |  87%  149 MB
|================================================================================          |  88%  149 MB
|================================================================================          |  88%  149 MB
|================================================================================          |  88%  149 MB
|================================================================================          |  88%  150 MB
|================================================================================          |  88%  150 MB
|================================================================================          |  88%  150 MB
|================================================================================          |  88%  150 MB
|================================================================================          |  88%  150 MB
|================================================================================          |  88%  150 MB
|================================================================================          |  88%  150 MB
|================================================================================          |  88%  150 MB
|================================================================================          |  88%  150 MB
|================================================================================          |  88%  151 MB
|================================================================================          |  88%  151 MB
|================================================================================          |  89%  151 MB
|=================================================================================         |  89%  151 MB
|=================================================================================         |  89%  151 MB
|=================================================================================         |  89%  151 MB
|=================================================================================         |  89%  151 MB
|=================================================================================         |  89%  151 MB
|=================================================================================         |  89%  152 MB
|=================================================================================         |  89%  152 MB
|=================================================================================         |  89%  152 MB
|=================================================================================         |  89%  152 MB
|=================================================================================         |  89%  152 MB
|=================================================================================         |  89%  152 MB
|=================================================================================         |  89%  152 MB
|=================================================================================         |  89%  152 MB
|=================================================================================         |  89%  152 MB
|=================================================================================         |  90%  153 MB
|=================================================================================         |  90%  153 MB
|==================================================================================        |  90%  153 MB
|==================================================================================        |  90%  153 MB
|==================================================================================        |  90%  153 MB
|==================================================================================        |  90%  153 MB
|==================================================================================        |  90%  153 MB
|==================================================================================        |  90%  153 MB
|==================================================================================        |  90%  153 MB
|==================================================================================        |  90%  154 MB
|==================================================================================        |  90%  154 MB
|==================================================================================        |  90%  154 MB
|==================================================================================        |  90%  154 MB
|==================================================================================        |  90%  154 MB
|==================================================================================        |  90%  154 MB
|==================================================================================        |  91%  154 MB
|==================================================================================        |  91%  154 MB
|==================================================================================        |  91%  155 MB
|===================================================================================       |  91%  155 MB
|===================================================================================       |  91%  155 MB
|===================================================================================       |  91%  155 MB
|===================================================================================       |  91%  155 MB
|===================================================================================       |  91%  155 MB
|===================================================================================       |  91%  155 MB
|===================================================================================       |  91%  155 MB
|===================================================================================       |  91%  155 MB
|===================================================================================       |  91%  156 MB
|===================================================================================       |  91%  156 MB
|===================================================================================       |  91%  156 MB
|===================================================================================       |  92%  156 MB
|===================================================================================       |  92%  156 MB
|===================================================================================       |  92%  156 MB
|===================================================================================       |  92%  156 MB
|===================================================================================       |  92%  156 MB
|====================================================================================      |  92%  156 MB
|====================================================================================      |  92%  157 MB
|====================================================================================      |  92%  157 MB
|====================================================================================      |  92%  157 MB
|====================================================================================      |  92%  157 MB
|====================================================================================      |  92%  157 MB
|====================================================================================      |  92%  157 MB
|====================================================================================      |  92%  157 MB
|====================================================================================      |  92%  157 MB
|====================================================================================      |  92%  158 MB
|====================================================================================      |  93%  158 MB
|====================================================================================      |  93%  158 MB
|====================================================================================      |  93%  158 MB
|====================================================================================      |  93%  158 MB
|====================================================================================      |  93%  158 MB
|====================================================================================      |  93%  158 MB
|=====================================================================================     |  93%  158 MB
|=====================================================================================     |  93%  158 MB
|=====================================================================================     |  93%  159 MB
|=====================================================================================     |  93%  159 MB
|=====================================================================================     |  93%  159 MB
|=====================================================================================     |  93%  159 MB
|=====================================================================================     |  93%  159 MB
|=====================================================================================     |  93%  159 MB
|=====================================================================================     |  93%  159 MB
|=====================================================================================     |  94%  159 MB
|=====================================================================================     |  94%  160 MB
|=====================================================================================     |  94%  160 MB
|=====================================================================================     |  94%  160 MB
|=====================================================================================     |  94%  160 MB
|=====================================================================================     |  94%  160 MB
|=====================================================================================     |  94%  160 MB
|======================================================================================    |  94%  160 MB
|======================================================================================    |  94%  160 MB
|======================================================================================    |  94%  160 MB
|======================================================================================    |  94%  161 MB
|======================================================================================    |  94%  161 MB
|======================================================================================    |  94%  161 MB
|======================================================================================    |  94%  161 MB
|======================================================================================    |  95%  161 MB
|======================================================================================    |  95%  161 MB
|======================================================================================    |  95%  161 MB
|======================================================================================    |  95%  161 MB
|======================================================================================    |  95%  162 MB
|======================================================================================    |  95%  162 MB
|======================================================================================    |  95%  162 MB
|======================================================================================    |  95%  162 MB
|======================================================================================    |  95%  162 MB
|=======================================================================================   |  95%  162 MB
|=======================================================================================   |  95%  162 MB
|=======================================================================================   |  95%  162 MB
|=======================================================================================   |  95%  162 MB
|=======================================================================================   |  95%  163 MB
|=======================================================================================   |  95%  163 MB
|=======================================================================================   |  96%  163 MB
|=======================================================================================   |  96%  163 MB
|=======================================================================================   |  96%  163 MB
|=======================================================================================   |  96%  163 MB
|=======================================================================================   |  96%  163 MB
|=======================================================================================   |  96%  163 MB
|=======================================================================================   |  96%  164 MB
|=======================================================================================   |  96%  164 MB
|=======================================================================================   |  96%  164 MB
|=======================================================================================   |  96%  164 MB
|========================================================================================  |  96%  164 MB
|========================================================================================  |  96%  164 MB
|========================================================================================  |  96%  164 MB
|========================================================================================  |  96%  164 MB
|========================================================================================  |  97%  165 MB
|========================================================================================  |  97%  165 MB
|========================================================================================  |  97%  165 MB
|========================================================================================  |  97%  165 MB
|========================================================================================  |  97%  165 MB
|========================================================================================  |  97%  165 MB
|========================================================================================  |  97%  165 MB
|========================================================================================  |  97%  165 MB
|========================================================================================  |  97%  165 MB
|========================================================================================  |  97%  166 MB
|========================================================================================  |  97%  166 MB
|========================================================================================= |  97%  166 MB
|========================================================================================= |  97%  166 MB
|========================================================================================= |  97%  166 MB
|========================================================================================= |  98%  166 MB
|========================================================================================= |  98%  166 MB
|========================================================================================= |  98%  166 MB
|========================================================================================= |  98%  167 MB
|========================================================================================= |  98%  167 MB
|========================================================================================= |  98%  167 MB
|========================================================================================= |  98%  167 MB
|========================================================================================= |  98%  167 MB
|========================================================================================= |  98%  167 MB
|========================================================================================= |  98%  167 MB
|========================================================================================= |  98%  167 MB
|========================================================================================= |  98%  168 MB
|========================================================================================= |  98%  168 MB
|==========================================================================================|  98%  168 MB
|==========================================================================================|  99%  168 MB
|==========================================================================================|  99%  168 MB
|==========================================================================================|  99%  168 MB
|==========================================================================================|  99%  168 MB
|==========================================================================================|  99%  168 MB
|==========================================================================================|  99%  168 MB
|==========================================================================================|  99%  169 MB
|==========================================================================================|  99%  169 MB
|==========================================================================================|  99%  169 MB
|==========================================================================================|  99%  169 MB
|==========================================================================================|  99%  169 MB
|==========================================================================================|  99%  169 MB
|==========================================================================================|  99%  169 MB
|==========================================================================================|  99%  169 MB
|==========================================================================================|  99%  169 MB
|===========================================================================================| 100%  170 MB
#read the downloaded file for all the building permits and then filter out the permits for dismantling
dismantle_permits <- read_csv("./data/Building_Permits_3_19_2018.csv", 
                             guess_max = 10^6) %>%
  filter(`Building Permit Type` == "Dismantle")
Parsed with column specification:
cols(
  .default = col_character(),
  `Parcel Size` = col_double(),
  `Parcel Cluster Sector` = col_integer(),
  Stories = col_double(),
  `Parcel Floor Area` = col_integer(),
  `Parcel Ground Area` = col_integer(),
  `Sequence Number` = col_integer()
)
See spec(...) for full column specifications.
  
#the files that contain the crime data
crime_to_12062016 <- 
  read_csv("./data/DPD__All_Crime_Incidents__January_1__2009_-_December_6__2016.csv",
           guess_max = 10^6)
Parsed with column specification:
cols(
  ROWNUM = col_integer(),
  CASEID = col_integer(),
  CRIMEID = col_integer(),
  CRNO = col_character(),
  CATEGORY = col_character(),
  OFFENSEDESCRIPTION = col_character(),
  STATEOFFENSEFILECLASS = col_integer(),
  INCIDENTDATE = col_character(),
  HOUR = col_integer(),
  SCA = col_integer(),
  PRECINCT = col_integer(),
  COUNCIL = col_character(),
  NEIGHBORHOOD = col_character(),
  CENSUSTRACT = col_double(),
  LOCATION = col_character()
)

|                                                                                                  |   0%
|                                                                                                  |   0%
|                                                                                                  |   0%
|                                                                                                  |   0%
|                                                                                                  |   0%
|                                                                                                  |   0%
|                                                                                                  |   0%
|                                                                                          |   0%    1 MB
|                                                                                          |   0%    1 MB
|                                                                                          |   0%    1 MB
|                                                                                          |   0%    1 MB
|                                                                                          |   0%    1 MB
|                                                                                          |   0%    1 MB
|                                                                                          |   0%    1 MB
|                                                                                          |   0%    1 MB
|                                                                                          |   0%    2 MB
|                                                                                          |   0%    2 MB
|                                                                                          |   1%    2 MB
|                                                                                          |   1%    2 MB
|=                                                                                         |   1%    2 MB
|=                                                                                         |   1%    2 MB
|=                                                                                         |   1%    2 MB
|=                                                                                         |   1%    2 MB
|=                                                                                         |   1%    3 MB
|=                                                                                         |   1%    3 MB
|=                                                                                         |   1%    3 MB
|=                                                                                         |   1%    3 MB
|=                                                                                         |   1%    3 MB
|=                                                                                         |   1%    3 MB
|=                                                                                         |   1%    3 MB
|=                                                                                         |   1%    4 MB
|=                                                                                         |   1%    4 MB
|=                                                                                         |   1%    4 MB
|=                                                                                         |   1%    4 MB
|=                                                                                         |   1%    4 MB
|=                                                                                         |   2%    4 MB
|=                                                                                         |   2%    4 MB
|=                                                                                         |   2%    4 MB
|=                                                                                         |   2%    5 MB
|==                                                                                        |   2%    5 MB
|==                                                                                        |   2%    5 MB
|==                                                                                        |   2%    5 MB
|==                                                                                        |   2%    5 MB
|==                                                                                        |   2%    5 MB
|==                                                                                        |   2%    5 MB
|==                                                                                        |   2%    5 MB
|==                                                                                        |   2%    6 MB
|==                                                                                        |   2%    6 MB
|==                                                                                        |   2%    6 MB
|==                                                                                        |   2%    6 MB
|==                                                                                        |   2%    6 MB
|==                                                                                        |   2%    6 MB
|==                                                                                        |   2%    6 MB
|==                                                                                        |   3%    6 MB
|==                                                                                        |   3%    7 MB
|==                                                                                        |   3%    7 MB
|==                                                                                        |   3%    7 MB
|==                                                                                        |   3%    7 MB
|==                                                                                        |   3%    7 MB
|===                                                                                       |   3%    7 MB
|===                                                                                       |   3%    7 MB
|===                                                                                       |   3%    7 MB
|===                                                                                       |   3%    8 MB
|===                                                                                       |   3%    8 MB
|===                                                                                       |   3%    8 MB
|===                                                                                       |   3%    8 MB
|===                                                                                       |   3%    8 MB
|===                                                                                       |   3%    8 MB
|===                                                                                       |   3%    8 MB
|===                                                                                       |   3%    8 MB
|===                                                                                       |   3%    9 MB
|===                                                                                       |   3%    9 MB
|===                                                                                       |   4%    9 MB
|===                                                                                       |   4%    9 MB
|===                                                                                       |   4%    9 MB
|===                                                                                       |   4%    9 MB
|===                                                                                       |   4%    9 MB
|===                                                                                       |   4%    9 MB
|===                                                                                       |   4%   10 MB
|====                                                                                      |   4%   10 MB
|====                                                                                      |   4%   10 MB
|====                                                                                      |   4%   10 MB
|====                                                                                      |   4%   10 MB
|====                                                                                      |   4%   10 MB
|====                                                                                      |   4%   10 MB
|====                                                                                      |   4%   10 MB
|====                                                                                      |   4%   11 MB
|====                                                                                      |   4%   11 MB
|====                                                                                      |   4%   11 MB
|====                                                                                      |   4%   11 MB
|====                                                                                      |   5%   11 MB
|====                                                                                      |   5%   11 MB
|====                                                                                      |   5%   11 MB
|====                                                                                      |   5%   11 MB
|====                                                                                      |   5%   12 MB
|====                                                                                      |   5%   12 MB
|====                                                                                      |   5%   12 MB
|====                                                                                      |   5%   12 MB
|====                                                                                      |   5%   12 MB
|=====                                                                                     |   5%   12 MB
|=====                                                                                     |   5%   12 MB
|=====                                                                                     |   5%   12 MB
|=====                                                                                     |   5%   13 MB
|=====                                                                                     |   5%   13 MB
|=====                                                                                     |   5%   13 MB
|=====                                                                                     |   5%   13 MB
|=====                                                                                     |   5%   13 MB
|=====                                                                                     |   5%   13 MB
|=====                                                                                     |   6%   13 MB
|=====                                                                                     |   6%   13 MB
|=====                                                                                     |   6%   14 MB
|=====                                                                                     |   6%   14 MB
|=====                                                                                     |   6%   14 MB
|=====                                                                                     |   6%   14 MB
|=====                                                                                     |   6%   14 MB
|=====                                                                                     |   6%   14 MB
|=====                                                                                     |   6%   14 MB
|=====                                                                                     |   6%   14 MB
|=====                                                                                     |   6%   15 MB
|======                                                                                    |   6%   15 MB
|======                                                                                    |   6%   15 MB
|======                                                                                    |   6%   15 MB
|======                                                                                    |   6%   15 MB
|======                                                                                    |   6%   15 MB
|======                                                                                    |   6%   15 MB
|======                                                                                    |   6%   15 MB
|======                                                                                    |   7%   16 MB
|======                                                                                    |   7%   16 MB
|======                                                                                    |   7%   16 MB
|======                                                                                    |   7%   16 MB
|======                                                                                    |   7%   16 MB
|======                                                                                    |   7%   16 MB
|======                                                                                    |   7%   16 MB
|======                                                                                    |   7%   16 MB
|======                                                                                    |   7%   17 MB
|======                                                                                    |   7%   17 MB
|======                                                                                    |   7%   17 MB
|======                                                                                    |   7%   17 MB
|=======                                                                                   |   7%   17 MB
|=======                                                                                   |   7%   17 MB
|=======                                                                                   |   7%   17 MB
|=======                                                                                   |   7%   18 MB
|=======                                                                                   |   7%   18 MB
|=======                                                                                   |   7%   18 MB
|=======                                                                                   |   8%   18 MB
|=======                                                                                   |   8%   18 MB
|=======                                                                                   |   8%   18 MB
|=======                                                                                   |   8%   18 MB
|=======                                                                                   |   8%   18 MB
|=======                                                                                   |   8%   19 MB
|=======                                                                                   |   8%   19 MB
|=======                                                                                   |   8%   19 MB
|=======                                                                                   |   8%   19 MB
|=======                                                                                   |   8%   19 MB
|=======                                                                                   |   8%   19 MB
|=======                                                                                   |   8%   19 MB
|=======                                                                                   |   8%   19 MB
|=======                                                                                   |   8%   20 MB
|========                                                                                  |   8%   20 MB
|========                                                                                  |   8%   20 MB
|========                                                                                  |   8%   20 MB
|========                                                                                  |   8%   20 MB
|========                                                                                  |   9%   20 MB
|========                                                                                  |   9%   20 MB
|========                                                                                  |   9%   20 MB
|========                                                                                  |   9%   21 MB
|========                                                                                  |   9%   21 MB
|========                                                                                  |   9%   21 MB
|========                                                                                  |   9%   21 MB
|========                                                                                  |   9%   21 MB
|========                                                                                  |   9%   21 MB
|========                                                                                  |   9%   21 MB
|========                                                                                  |   9%   21 MB
|========                                                                                  |   9%   22 MB
|========                                                                                  |   9%   22 MB
|========                                                                                  |   9%   22 MB
|========                                                                                  |   9%   22 MB
|========                                                                                  |   9%   22 MB
|=========                                                                                 |   9%   22 MB
|=========                                                                                 |   9%   22 MB
|=========                                                                                 |  10%   22 MB
|=========                                                                                 |  10%   23 MB
|=========                                                                                 |  10%   23 MB
|=========                                                                                 |  10%   23 MB
|=========                                                                                 |  10%   23 MB
|=========                                                                                 |  10%   23 MB
|=========                                                                                 |  10%   23 MB
|=========                                                                                 |  10%   23 MB
|=========                                                                                 |  10%   23 MB
|=========                                                                                 |  10%   24 MB
|=========                                                                                 |  10%   24 MB
|=========                                                                                 |  10%   24 MB
|=========                                                                                 |  10%   24 MB
|=========                                                                                 |  10%   24 MB
|=========                                                                                 |  10%   24 MB
|=========                                                                                 |  10%   24 MB
|=========                                                                                 |  10%   24 MB
|=========                                                                                 |  10%   25 MB
|==========                                                                                |  11%   25 MB
|==========                                                                                |  11%   25 MB
|==========                                                                                |  11%   25 MB
|==========                                                                                |  11%   25 MB
|==========                                                                                |  11%   25 MB
|==========                                                                                |  11%   25 MB
|==========                                                                                |  11%   26 MB
|==========                                                                                |  11%   26 MB
|==========                                                                                |  11%   26 MB
|==========                                                                                |  11%   26 MB
|==========                                                                                |  11%   26 MB
|==========                                                                                |  11%   26 MB
|==========                                                                                |  11%   26 MB
|==========                                                                                |  11%   26 MB
|==========                                                                                |  11%   27 MB
|==========                                                                                |  11%   27 MB
|==========                                                                                |  11%   27 MB
|==========                                                                                |  11%   27 MB
|==========                                                                                |  12%   27 MB
|==========                                                                                |  12%   27 MB
|===========                                                                               |  12%   27 MB
|===========                                                                               |  12%   27 MB
|===========                                                                               |  12%   28 MB
|===========                                                                               |  12%   28 MB
|===========                                                                               |  12%   28 MB
|===========                                                                               |  12%   28 MB
|===========                                                                               |  12%   28 MB
|===========                                                                               |  12%   28 MB
|===========                                                                               |  12%   28 MB
|===========                                                                               |  12%   28 MB
|===========                                                                               |  12%   29 MB
|===========                                                                               |  12%   29 MB
|===========                                                                               |  12%   29 MB
|===========                                                                               |  12%   29 MB
|===========                                                                               |  12%   29 MB
|===========                                                                               |  12%   29 MB
|===========                                                                               |  13%   29 MB
|===========                                                                               |  13%   29 MB
|===========                                                                               |  13%   30 MB
|============                                                                              |  13%   30 MB
|============                                                                              |  13%   30 MB
|============                                                                              |  13%   30 MB
|============                                                                              |  13%   30 MB
|============                                                                              |  13%   30 MB
|============                                                                              |  13%   30 MB
|============                                                                              |  13%   30 MB
|============                                                                              |  13%   31 MB
|============                                                                              |  13%   31 MB
|============                                                                              |  13%   31 MB
|============                                                                              |  13%   31 MB
|============                                                                              |  13%   31 MB
|============                                                                              |  13%   31 MB
|============                                                                              |  13%   31 MB
|============                                                                              |  13%   31 MB
|============                                                                              |  14%   32 MB
|============                                                                              |  14%   32 MB
|============                                                                              |  14%   32 MB
|============                                                                              |  14%   32 MB
|============                                                                              |  14%   32 MB
|=============                                                                             |  14%   32 MB
|=============                                                                             |  14%   32 MB
|=============                                                                             |  14%   33 MB
|=============                                                                             |  14%   33 MB
|=============                                                                             |  14%   33 MB
|=============                                                                             |  14%   33 MB
|=============                                                                             |  14%   33 MB
|=============                                                                             |  14%   33 MB
|=============                                                                             |  14%   33 MB
|=============                                                                             |  14%   33 MB
|=============                                                                             |  14%   34 MB
|=============                                                                             |  14%   34 MB
|=============                                                                             |  14%   34 MB
|=============                                                                             |  15%   34 MB
|=============                                                                             |  15%   34 MB
|=============                                                                             |  15%   34 MB
|=============                                                                             |  15%   34 MB
|=============                                                                             |  15%   34 MB
|=============                                                                             |  15%   35 MB
|=============                                                                             |  15%   35 MB
|==============                                                                            |  15%   35 MB
|==============                                                                            |  15%   35 MB
|==============                                                                            |  15%   35 MB
|==============                                                                            |  15%   35 MB
|==============                                                                            |  15%   35 MB
|==============                                                                            |  15%   35 MB
|==============                                                                            |  15%   36 MB
|==============                                                                            |  15%   36 MB
|==============                                                                            |  15%   36 MB
|==============                                                                            |  15%   36 MB
|==============                                                                            |  15%   36 MB
|==============                                                                            |  16%   36 MB
|==============                                                                            |  16%   36 MB
|==============                                                                            |  16%   36 MB
|==============                                                                            |  16%   37 MB
|==============                                                                            |  16%   37 MB
|==============                                                                            |  16%   37 MB
|==============                                                                            |  16%   37 MB
|==============                                                                            |  16%   37 MB
|==============                                                                            |  16%   37 MB
|===============                                                                           |  16%   37 MB
|===============                                                                           |  16%   37 MB
|===============                                                                           |  16%   38 MB
|===============                                                                           |  16%   38 MB
|===============                                                                           |  16%   38 MB
|===============                                                                           |  16%   38 MB
|===============                                                                           |  16%   38 MB
|===============                                                                           |  16%   38 MB
|===============                                                                           |  16%   38 MB
|===============                                                                           |  16%   38 MB
|===============                                                                           |  17%   39 MB
|===============                                                                           |  17%   39 MB
|===============                                                                           |  17%   39 MB
|===============                                                                           |  17%   39 MB
|===============                                                                           |  17%   39 MB
|===============                                                                           |  17%   39 MB
|===============                                                                           |  17%   39 MB
|===============                                                                           |  17%   39 MB
|===============                                                                           |  17%   40 MB
|===============                                                                           |  17%   40 MB
|================                                                                          |  17%   40 MB
|================                                                                          |  17%   40 MB
|================                                                                          |  17%   40 MB
|================                                                                          |  17%   40 MB
|================                                                                          |  17%   40 MB
|================                                                                          |  17%   40 MB
|================                                                                          |  17%   41 MB
|================                                                                          |  17%   41 MB
|================                                                                          |  18%   41 MB
|================                                                                          |  18%   41 MB
|================                                                                          |  18%   41 MB
|================                                                                          |  18%   41 MB
|================                                                                          |  18%   41 MB
|================                                                                          |  18%   41 MB
|================                                                                          |  18%   42 MB
|================                                                                          |  18%   42 MB
|================                                                                          |  18%   42 MB
|================                                                                          |  18%   42 MB
|================                                                                          |  18%   42 MB
|================                                                                          |  18%   42 MB
|=================                                                                         |  18%   42 MB
|=================                                                                         |  18%   43 MB
|=================                                                                         |  18%   43 MB
|=================                                                                         |  18%   43 MB
|=================                                                                         |  18%   43 MB
|=================                                                                         |  18%   43 MB
|=================                                                                         |  19%   43 MB
|=================                                                                         |  19%   43 MB
|=================                                                                         |  19%   43 MB
|=================                                                                         |  19%   44 MB
|=================                                                                         |  19%   44 MB
|=================                                                                         |  19%   44 MB
|=================                                                                         |  19%   44 MB
|=================                                                                         |  19%   44 MB
|=================                                                                         |  19%   44 MB
|=================                                                                         |  19%   44 MB
|=================                                                                         |  19%   44 MB
|=================                                                                         |  19%   45 MB
|=================                                                                         |  19%   45 MB
|=================                                                                         |  19%   45 MB
|==================                                                                        |  19%   45 MB
|==================                                                                        |  19%   45 MB
|==================                                                                        |  19%   45 MB
|==================                                                                        |  19%   45 MB
|==================                                                                        |  20%   45 MB
|==================                                                                        |  20%   46 MB
|==================                                                                        |  20%   46 MB
|==================                                                                        |  20%   46 MB
|==================                                                                        |  20%   46 MB
|==================                                                                        |  20%   46 MB
|==================                                                                        |  20%   46 MB
|==================                                                                        |  20%   46 MB
|==================                                                                        |  20%   46 MB
|==================                                                                        |  20%   47 MB
|==================                                                                        |  20%   47 MB
|==================                                                                        |  20%   47 MB
|==================                                                                        |  20%   47 MB
|==================                                                                        |  20%   47 MB
|==================                                                                        |  20%   47 MB
|==================                                                                        |  20%   47 MB
|===================                                                                       |  20%   47 MB
|===================                                                                       |  20%   48 MB
|===================                                                                       |  21%   48 MB
|===================                                                                       |  21%   48 MB
|===================                                                                       |  21%   48 MB
|===================                                                                       |  21%   48 MB
|===================                                                                       |  21%   48 MB
|===================                                                                       |  21%   48 MB
|===================                                                                       |  21%   48 MB
|===================                                                                       |  21%   49 MB
|===================                                                                       |  21%   49 MB
|===================                                                                       |  21%   49 MB
|===================                                                                       |  21%   49 MB
|===================                                                                       |  21%   49 MB
|===================                                                                       |  21%   49 MB
|===================                                                                       |  21%   49 MB
|===================                                                                       |  21%   49 MB
|===================                                                                       |  21%   50 MB
|===================                                                                       |  21%   50 MB
|====================                                                                      |  21%   50 MB
|====================                                                                      |  22%   50 MB
|====================                                                                      |  22%   50 MB
|====================                                                                      |  22%   50 MB
|====================                                                                      |  22%   50 MB
|====================                                                                      |  22%   50 MB
|====================                                                                      |  22%   51 MB
|====================                                                                      |  22%   51 MB
|====================                                                                      |  22%   51 MB
|====================                                                                      |  22%   51 MB
|====================                                                                      |  22%   51 MB
|====================                                                                      |  22%   51 MB
|====================                                                                      |  22%   51 MB
|====================                                                                      |  22%   52 MB
|====================                                                                      |  22%   52 MB
|====================                                                                      |  22%   52 MB
|====================                                                                      |  22%   52 MB
|====================                                                                      |  22%   52 MB
|====================                                                                      |  22%   52 MB
|====================                                                                      |  23%   52 MB
|=====================                                                                     |  23%   52 MB
|=====================                                                                     |  23%   53 MB
|=====================                                                                     |  23%   53 MB
|=====================                                                                     |  23%   53 MB
|=====================                                                                     |  23%   53 MB
|=====================                                                                     |  23%   53 MB
|=====================                                                                     |  23%   53 MB
|=====================                                                                     |  23%   53 MB
|=====================                                                                     |  23%   53 MB
|=====================                                                                     |  23%   54 MB
|=====================                                                                     |  23%   54 MB
|=====================                                                                     |  23%   54 MB
|=====================                                                                     |  23%   54 MB
|=====================                                                                     |  23%   54 MB
|=====================                                                                     |  23%   54 MB
|=====================                                                                     |  23%   54 MB
|=====================                                                                     |  23%   54 MB
|=====================                                                                     |  24%   55 MB
|=====================                                                                     |  24%   55 MB
|=====================                                                                     |  24%   55 MB
|======================                                                                    |  24%   55 MB
|======================                                                                    |  24%   55 MB
|======================                                                                    |  24%   55 MB
|======================                                                                    |  24%   55 MB
|======================                                                                    |  24%   55 MB
|======================                                                                    |  24%   56 MB
|======================                                                                    |  24%   56 MB
|======================                                                                    |  24%   56 MB
|======================                                                                    |  24%   56 MB
|======================                                                                    |  24%   56 MB
|======================                                                                    |  24%   56 MB
|======================                                                                    |  24%   56 MB
|======================                                                                    |  24%   56 MB
|======================                                                                    |  24%   57 MB
|======================                                                                    |  24%   57 MB
|======================                                                                    |  25%   57 MB
|======================                                                                    |  25%   57 MB
|======================                                                                    |  25%   57 MB
|======================                                                                    |  25%   57 MB
|======================                                                                    |  25%   57 MB
|=======================                                                                   |  25%   57 MB
|=======================                                                                   |  25%   58 MB
|=======================                                                                   |  25%   58 MB
|=======================                                                                   |  25%   58 MB
|=======================                                                                   |  25%   58 MB
|=======================                                                                   |  25%   58 MB
|=======================                                                                   |  25%   58 MB
|=======================                                                                   |  25%   58 MB
|=======================                                                                   |  25%   58 MB
|=======================                                                                   |  25%   59 MB
|=======================                                                                   |  25%   59 MB
|=======================                                                                   |  25%   59 MB
|=======================                                                                   |  25%   59 MB
|=======================                                                                   |  26%   59 MB
|=======================                                                                   |  26%   59 MB
|=======================                                                                   |  26%   59 MB
|=======================                                                                   |  26%   59 MB
|=======================                                                                   |  26%   60 MB
|=======================                                                                   |  26%   60 MB
|=======================                                                                   |  26%   60 MB
|========================                                                                  |  26%   60 MB
|========================                                                                  |  26%   60 MB
|========================                                                                  |  26%   60 MB
|========================                                                                  |  26%   60 MB
|========================                                                                  |  26%   61 MB
|========================                                                                  |  26%   61 MB
|========================                                                                  |  26%   61 MB
|========================                                                                  |  26%   61 MB
|========================                                                                  |  26%   61 MB
|========================                                                                  |  26%   61 MB
|========================                                                                  |  26%   61 MB
|========================                                                                  |  27%   61 MB
|========================                                                                  |  27%   62 MB
|========================                                                                  |  27%   62 MB
|========================                                                                  |  27%   62 MB
|========================                                                                  |  27%   62 MB
|========================                                                                  |  27%   62 MB
|========================                                                                  |  27%   62 MB
|========================                                                                  |  27%   62 MB
|========================                                                                  |  27%   62 MB
|=========================                                                                 |  27%   63 MB
|=========================                                                                 |  27%   63 MB
|=========================                                                                 |  27%   63 MB
|=========================                                                                 |  27%   63 MB
|=========================                                                                 |  27%   63 MB
|=========================                                                                 |  27%   63 MB
|=========================                                                                 |  27%   63 MB
|=========================                                                                 |  27%   63 MB
|=========================                                                                 |  27%   64 MB
|=========================                                                                 |  28%   64 MB
|=========================                                                                 |  28%   64 MB
|=========================                                                                 |  28%   64 MB
|=========================                                                                 |  28%   64 MB
|=========================                                                                 |  28%   64 MB
|=========================                                                                 |  28%   64 MB
|=========================                                                                 |  28%   64 MB
|=========================                                                                 |  28%   65 MB
|=========================                                                                 |  28%   65 MB
|=========================                                                                 |  28%   65 MB
|=========================                                                                 |  28%   65 MB
|==========================                                                                |  28%   65 MB
|==========================                                                                |  28%   65 MB
|==========================                                                                |  28%   65 MB
|==========================                                                                |  28%   65 MB
|==========================                                                                |  28%   66 MB
|==========================                                                                |  28%   66 MB
|==========================                                                                |  28%   66 MB
|==========================                                                                |  29%   66 MB
|==========================                                                                |  29%   66 MB
|==========================                                                                |  29%   66 MB
|==========================                                                                |  29%   66 MB
|==========================                                                                |  29%   66 MB
|==========================                                                                |  29%   67 MB
|==========================                                                                |  29%   67 MB
|==========================                                                                |  29%   67 MB
|==========================                                                                |  29%   67 MB
|==========================                                                                |  29%   67 MB
|==========================                                                                |  29%   67 MB
|==========================                                                                |  29%   67 MB
|==========================                                                                |  29%   67 MB
|===========================                                                               |  29%   68 MB
|===========================                                                               |  29%   68 MB
|===========================                                                               |  29%   68 MB
|===========================                                                               |  29%   68 MB
|===========================                                                               |  29%   68 MB
|===========================                                                               |  29%   68 MB
|===========================                                                               |  30%   68 MB
|===========================                                                               |  30%   68 MB
|===========================                                                               |  30%   69 MB
|===========================                                                               |  30%   69 MB
|===========================                                                               |  30%   69 MB
|===========================                                                               |  30%   69 MB
|===========================                                                               |  30%   69 MB
|===========================                                                               |  30%   69 MB
|===========================                                                               |  30%   69 MB
|===========================                                                               |  30%   69 MB
|===========================                                                               |  30%   70 MB
|===========================                                                               |  30%   70 MB
|===========================                                                               |  30%   70 MB
|===========================                                                               |  30%   70 MB
|============================                                                              |  30%   70 MB
|============================                                                              |  30%   70 MB
|============================                                                              |  30%   70 MB
|============================                                                              |  30%   70 MB
|============================                                                              |  31%   71 MB
|============================                                                              |  31%   71 MB
|============================                                                              |  31%   71 MB
|============================                                                              |  31%   71 MB
|============================                                                              |  31%   71 MB
|============================                                                              |  31%   71 MB
|============================                                                              |  31%   71 MB
|============================                                                              |  31%   71 MB
|============================                                                              |  31%   72 MB
|============================                                                              |  31%   72 MB
|============================                                                              |  31%   72 MB
|============================                                                              |  31%   72 MB
|============================                                                              |  31%   72 MB
|============================                                                              |  31%   72 MB
|============================                                                              |  31%   72 MB
|============================                                                              |  31%   72 MB
|=============================                                                             |  31%   73 MB
|=============================                                                             |  31%   73 MB
|=============================                                                             |  32%   73 MB
|=============================                                                             |  32%   73 MB
|=============================                                                             |  32%   73 MB
|=============================                                                             |  32%   73 MB
|=============================                                                             |  32%   73 MB
|=============================                                                             |  32%   73 MB
|=============================                                                             |  32%   74 MB
|=============================                                                             |  32%   74 MB
|=============================                                                             |  32%   74 MB
|=============================                                                             |  32%   74 MB
|=============================                                                             |  32%   74 MB
|=============================                                                             |  32%   74 MB
|=============================                                                             |  32%   74 MB
|=============================                                                             |  32%   74 MB
|=============================                                                             |  32%   75 MB
|=============================                                                             |  32%   75 MB
|=============================                                                             |  32%   75 MB
|=============================                                                             |  32%   75 MB
|==============================                                                            |  32%   75 MB
|==============================                                                            |  33%   75 MB
|==============================                                                            |  33%   75 MB
|==============================                                                            |  33%   75 MB
|==============================                                                            |  33%   76 MB
|==============================                                                            |  33%   76 MB
|==============================                                                            |  33%   76 MB
|==============================                                                            |  33%   76 MB
|==============================                                                            |  33%   76 MB
|==============================                                                            |  33%   76 MB
|==============================                                                            |  33%   76 MB
|==============================                                                            |  33%   76 MB
|==============================                                                            |  33%   77 MB
|==============================                                                            |  33%   77 MB
|==============================                                                            |  33%   77 MB
|==============================                                                            |  33%   77 MB
|==============================                                                            |  33%   77 MB
|==============================                                                            |  33%   77 MB
|==============================                                                            |  33%   77 MB
|==============================                                                            |  34%   77 MB
|===============================                                                           |  34%   78 MB
|===============================                                                           |  34%   78 MB
|===============================                                                           |  34%   78 MB
|===============================                                                           |  34%   78 MB
|===============================                                                           |  34%   78 MB
|===============================                                                           |  34%   78 MB
|===============================                                                           |  34%   78 MB
|===============================                                                           |  34%   78 MB
|===============================                                                           |  34%   79 MB
|===============================                                                           |  34%   79 MB
|===============================                                                           |  34%   79 MB
|===============================                                                           |  34%   79 MB
|===============================                                                           |  34%   79 MB
|===============================                                                           |  34%   79 MB
|===============================                                                           |  34%   79 MB
|===============================                                                           |  34%   80 MB
|===============================                                                           |  34%   80 MB
|===============================                                                           |  35%   80 MB
|===============================                                                           |  35%   80 MB
|===============================                                                           |  35%   80 MB
|================================                                                          |  35%   80 MB
|================================                                                          |  35%   80 MB
|================================                                                          |  35%   80 MB
|================================                                                          |  35%   81 MB
|================================                                                          |  35%   81 MB
|================================                                                          |  35%   81 MB
|================================                                                          |  35%   81 MB
|================================                                                          |  35%   81 MB
|================================                                                          |  35%   81 MB
|================================                                                          |  35%   81 MB
|================================                                                          |  35%   81 MB
|================================                                                          |  35%   82 MB
|================================                                                          |  35%   82 MB
|================================                                                          |  35%   82 MB
|================================                                                          |  35%   82 MB
|================================                                                          |  36%   82 MB
|================================                                                          |  36%   82 MB
|================================                                                          |  36%   82 MB
|================================                                                          |  36%   82 MB
|================================                                                          |  36%   83 MB
|=================================                                                         |  36%   83 MB
|=================================                                                         |  36%   83 MB
|=================================                                                         |  36%   83 MB
|=================================                                                         |  36%   83 MB
|=================================                                                         |  36%   83 MB
|=================================                                                         |  36%   83 MB
|=================================                                                         |  36%   83 MB
|=================================                                                         |  36%   84 MB
|=================================                                                         |  36%   84 MB
|=================================                                                         |  36%   84 MB
|=================================                                                         |  36%   84 MB
|=================================                                                         |  36%   84 MB
|=================================                                                         |  36%   84 MB
|=================================                                                         |  37%   84 MB
|=================================                                                         |  37%   84 MB
|=================================                                                         |  37%   85 MB
|=================================                                                         |  37%   85 MB
|=================================                                                         |  37%   85 MB
|=================================                                                         |  37%   85 MB
|=================================                                                         |  37%   85 MB
|==================================                                                        |  37%   85 MB
|==================================                                                        |  37%   85 MB
|==================================                                                        |  37%   85 MB
|==================================                                                        |  37%   86 MB
|==================================                                                        |  37%   86 MB
|==================================                                                        |  37%   86 MB
|==================================                                                        |  37%   86 MB
|==================================                                                        |  37%   86 MB
|==================================                                                        |  37%   86 MB
|==================================                                                        |  37%   86 MB
|==================================                                                        |  37%   86 MB
|==================================                                                        |  37%   87 MB
|==================================                                                        |  38%   87 MB
|==================================                                                        |  38%   87 MB
|==================================                                                        |  38%   87 MB
|==================================                                                        |  38%   87 MB
|==================================                                                        |  38%   87 MB
|==================================                                                        |  38%   87 MB
|==================================                                                        |  38%   87 MB
|==================================                                                        |  38%   88 MB
|===================================                                                       |  38%   88 MB
|===================================                                                       |  38%   88 MB
|===================================                                                       |  38%   88 MB
|===================================                                                       |  38%   88 MB
|===================================                                                       |  38%   88 MB
|===================================                                                       |  38%   88 MB
|===================================                                                       |  38%   88 MB
|===================================                                                       |  38%   89 MB
|===================================                                                       |  38%   89 MB
|===================================                                                       |  38%   89 MB
|===================================                                                       |  39%   89 MB
|===================================                                                       |  39%   89 MB
|===================================                                                       |  39%   89 MB
|===================================                                                       |  39%   89 MB
|===================================                                                       |  39%   89 MB
|===================================                                                       |  39%   90 MB
|===================================                                                       |  39%   90 MB
|===================================                                                       |  39%   90 MB
|===================================                                                       |  39%   90 MB
|===================================                                                       |  39%   90 MB
|====================================                                                      |  39%   90 MB
|====================================                                                      |  39%   90 MB
|====================================                                                      |  39%   90 MB
|====================================                                                      |  39%   91 MB
|====================================                                                      |  39%   91 MB
|====================================                                                      |  39%   91 MB
|====================================                                                      |  39%   91 MB
|====================================                                                      |  39%   91 MB
|====================================                                                      |  40%   91 MB
|====================================                                                      |  40%   91 MB
|====================================                                                      |  40%   91 MB
|====================================                                                      |  40%   92 MB
|====================================                                                      |  40%   92 MB
|====================================                                                      |  40%   92 MB
|====================================                                                      |  40%   92 MB
|====================================                                                      |  40%   92 MB
|====================================                                                      |  40%   92 MB
|====================================                                                      |  40%   92 MB
|====================================                                                      |  40%   92 MB
|====================================                                                      |  40%   93 MB
|=====================================                                                     |  40%   93 MB
|=====================================                                                     |  40%   93 MB
|=====================================                                                     |  40%   93 MB
|=====================================                                                     |  40%   93 MB
|=====================================                                                     |  40%   93 MB
|=====================================                                                     |  40%   93 MB
|=====================================                                                     |  40%   93 MB
|=====================================                                                     |  41%   94 MB
|=====================================                                                     |  41%   94 MB
|=====================================                                                     |  41%   94 MB
|=====================================                                                     |  41%   94 MB
|=====================================                                                     |  41%   94 MB
|=====================================                                                     |  41%   94 MB
|=====================================                                                     |  41%   94 MB
|=====================================                                                     |  41%   94 MB
|=====================================                                                     |  41%   95 MB
|=====================================                                                     |  41%   95 MB
|=====================================                                                     |  41%   95 MB
|=====================================                                                     |  41%   95 MB
|=====================================                                                     |  41%   95 MB
|=====================================                                                     |  41%   95 MB
|======================================                                                    |  41%   95 MB
|======================================                                                    |  41%   95 MB
|======================================                                                    |  41%   96 MB
|======================================                                                    |  41%   96 MB
|======================================                                                    |  42%   96 MB
|======================================                                                    |  42%   96 MB
|======================================                                                    |  42%   96 MB
|======================================                                                    |  42%   96 MB
|======================================                                                    |  42%   96 MB
|======================================                                                    |  42%   96 MB
|======================================                                                    |  42%   97 MB
|======================================                                                    |  42%   97 MB
|======================================                                                    |  42%   97 MB
|======================================                                                    |  42%   97 MB
|======================================                                                    |  42%   97 MB
|======================================                                                    |  42%   97 MB
|======================================                                                    |  42%   97 MB
|======================================                                                    |  42%   97 MB
|======================================                                                    |  42%   98 MB
|======================================                                                    |  42%   98 MB
|=======================================                                                   |  42%   98 MB
|=======================================                                                   |  42%   98 MB
|=======================================                                                   |  43%   98 MB
|=======================================                                                   |  43%   98 MB
|=======================================                                                   |  43%   98 MB
|=======================================                                                   |  43%   98 MB
|=======================================                                                   |  43%   99 MB
|=======================================                                                   |  43%   99 MB
|=======================================                                                   |  43%   99 MB
|=======================================                                                   |  43%   99 MB
|=======================================                                                   |  43%   99 MB
|=======================================                                                   |  43%   99 MB
|=======================================                                                   |  43%   99 MB
|=======================================                                                   |  43%   99 MB
|=======================================                                                   |  43%  100 MB
|=======================================                                                   |  43%  100 MB
|=======================================                                                   |  43%  100 MB
|=======================================                                                   |  43%  100 MB
|=======================================                                                   |  43%  100 MB
|=======================================                                                   |  43%  100 MB
|========================================                                                  |  43%  100 MB
|========================================                                                  |  44%  100 MB
|========================================                                                  |  44%  101 MB
|========================================                                                  |  44%  101 MB
|========================================                                                  |  44%  101 MB
|========================================                                                  |  44%  101 MB
|========================================                                                  |  44%  101 MB
|========================================                                                  |  44%  101 MB
|========================================                                                  |  44%  101 MB
|========================================                                                  |  44%  101 MB
|========================================                                                  |  44%  102 MB
|========================================                                                  |  44%  102 MB
|========================================                                                  |  44%  102 MB
|========================================                                                  |  44%  102 MB
|========================================                                                  |  44%  102 MB
|========================================                                                  |  44%  102 MB
|========================================                                                  |  44%  102 MB
|========================================                                                  |  44%  102 MB
|========================================                                                  |  44%  103 MB
|========================================                                                  |  45%  103 MB
|=========================================                                                 |  45%  103 MB
|=========================================                                                 |  45%  103 MB
|=========================================                                                 |  45%  103 MB
|=========================================                                                 |  45%  103 MB
|=========================================                                                 |  45%  103 MB
|=========================================                                                 |  45%  103 MB
|=========================================                                                 |  45%  104 MB
|=========================================                                                 |  45%  104 MB
|=========================================                                                 |  45%  104 MB
|=========================================                                                 |  45%  104 MB
|=========================================                                                 |  45%  104 MB
|=========================================                                                 |  45%  104 MB
|=========================================                                                 |  45%  104 MB
|=========================================                                                 |  45%  104 MB
|=========================================                                                 |  45%  105 MB
|=========================================                                                 |  45%  105 MB
|=========================================                                                 |  45%  105 MB
|=========================================                                                 |  46%  105 MB
|=========================================                                                 |  46%  105 MB
|=========================================                                                 |  46%  105 MB
|==========================================                                                |  46%  105 MB
|==========================================                                                |  46%  105 MB
|==========================================                                                |  46%  106 MB
|==========================================                                                |  46%  106 MB
|==========================================                                                |  46%  106 MB
|==========================================                                                |  46%  106 MB
|==========================================                                                |  46%  106 MB
|==========================================                                                |  46%  106 MB
|==========================================                                                |  46%  106 MB
|==========================================                                                |  46%  106 MB
|==========================================                                                |  46%  107 MB
|==========================================                                                |  46%  107 MB
|==========================================                                                |  46%  107 MB
|==========================================                                                |  46%  107 MB
|==========================================                                                |  46%  107 MB
|==========================================                                                |  46%  107 MB
|==========================================                                                |  47%  107 MB
|==========================================                                                |  47%  107 MB
|==========================================                                                |  47%  108 MB
|==========================================                                                |  47%  108 MB
|===========================================                                               |  47%  108 MB
|===========================================                                               |  47%  108 MB
|===========================================                                               |  47%  108 MB
|===========================================                                               |  47%  108 MB
|===========================================                                               |  47%  108 MB
|===========================================                                               |  47%  108 MB
|===========================================                                               |  47%  109 MB
|===========================================                                               |  47%  109 MB
|===========================================                                               |  47%  109 MB
|===========================================                                               |  47%  109 MB
|===========================================                                               |  47%  109 MB
|===========================================                                               |  47%  109 MB
|===========================================                                               |  47%  109 MB
|===========================================                                               |  47%  109 MB
|===========================================                                               |  48%  110 MB
|===========================================                                               |  48%  110 MB
|===========================================                                               |  48%  110 MB
|===========================================                                               |  48%  110 MB
|===========================================                                               |  48%  110 MB
|===========================================                                               |  48%  110 MB
|============================================                                              |  48%  110 MB
|============================================                                              |  48%  110 MB
|============================================                                              |  48%  111 MB
|============================================                                              |  48%  111 MB
|============================================                                              |  48%  111 MB
|============================================                                              |  48%  111 MB
|============================================                                              |  48%  111 MB
|============================================                                              |  48%  111 MB
|============================================                                              |  48%  111 MB
|============================================                                              |  48%  111 MB
|============================================                                              |  48%  112 MB
|============================================                                              |  48%  112 MB
|============================================                                              |  49%  112 MB
|============================================                                              |  49%  112 MB
|============================================                                              |  49%  112 MB
|============================================                                              |  49%  112 MB
|============================================                                              |  49%  112 MB
|============================================                                              |  49%  112 MB
|============================================                                              |  49%  113 MB
|============================================                                              |  49%  113 MB
|=============================================                                             |  49%  113 MB
|=============================================                                             |  49%  113 MB
|=============================================                                             |  49%  113 MB
|=============================================                                             |  49%  113 MB
|=============================================                                             |  49%  113 MB
|=============================================                                             |  49%  113 MB
|=============================================                                             |  49%  114 MB
|=============================================                                             |  49%  114 MB
|=============================================                                             |  49%  114 MB
|=============================================                                             |  49%  114 MB
|=============================================                                             |  50%  114 MB
|=============================================                                             |  50%  114 MB
|=============================================                                             |  50%  114 MB
|=============================================                                             |  50%  114 MB
|=============================================                                             |  50%  115 MB
|=============================================                                             |  50%  115 MB
|=============================================                                             |  50%  115 MB
|=============================================                                             |  50%  115 MB
|=============================================                                             |  50%  115 MB
|=============================================                                             |  50%  115 MB
|=============================================                                             |  50%  115 MB
|==============================================                                            |  50%  115 MB
|==============================================                                            |  50%  116 MB
|==============================================                                            |  50%  116 MB
|==============================================                                            |  50%  116 MB
|==============================================                                            |  50%  116 MB
|==============================================                                            |  50%  116 MB
|==============================================                                            |  50%  116 MB
|==============================================                                            |  50%  116 MB
|==============================================                                            |  51%  116 MB
|==============================================                                            |  51%  117 MB
|==============================================                                            |  51%  117 MB
|==============================================                                            |  51%  117 MB
|==============================================                                            |  51%  117 MB
|==============================================                                            |  51%  117 MB
|==============================================                                            |  51%  117 MB
|==============================================                                            |  51%  117 MB
|==============================================                                            |  51%  117 MB
|==============================================                                            |  51%  118 MB
|==============================================                                            |  51%  118 MB
|===============================================                                           |  51%  118 MB
|===============================================                                           |  51%  118 MB
|===============================================                                           |  51%  118 MB
|===============================================                                           |  51%  118 MB
|===============================================                                           |  51%  118 MB
|===============================================                                           |  51%  118 MB
|===============================================                                           |  51%  119 MB
|===============================================                                           |  52%  119 MB
|===============================================                                           |  52%  119 MB
|===============================================                                           |  52%  119 MB
|===============================================                                           |  52%  119 MB
|===============================================                                           |  52%  119 MB
|===============================================                                           |  52%  119 MB
|===============================================                                           |  52%  119 MB
|===============================================                                           |  52%  120 MB
|===============================================                                           |  52%  120 MB
|===============================================                                           |  52%  120 MB
|===============================================                                           |  52%  120 MB
|===============================================                                           |  52%  120 MB
|===============================================                                           |  52%  120 MB
|================================================                                          |  52%  120 MB
|================================================                                          |  52%  120 MB
|================================================                                          |  52%  121 MB
|================================================                                          |  52%  121 MB
|================================================                                          |  52%  121 MB
|================================================                                          |  53%  121 MB
|================================================                                          |  53%  121 MB
|================================================                                          |  53%  121 MB
|================================================                                          |  53%  121 MB
|================================================                                          |  53%  121 MB
|================================================                                          |  53%  122 MB
|================================================                                          |  53%  122 MB
|================================================                                          |  53%  122 MB
|================================================                                          |  53%  122 MB
|================================================                                          |  53%  122 MB
|================================================                                          |  53%  122 MB
|================================================                                          |  53%  122 MB
|================================================                                          |  53%  122 MB
|================================================                                          |  53%  123 MB
|================================================                                          |  53%  123 MB
|================================================                                          |  53%  123 MB
|=================================================                                         |  53%  123 MB
|=================================================                                         |  53%  123 MB
|=================================================                                         |  54%  123 MB
|=================================================                                         |  54%  123 MB
|=================================================                                         |  54%  123 MB
|=================================================                                         |  54%  124 MB
|=================================================                                         |  54%  124 MB
|=================================================                                         |  54%  124 MB
|=================================================                                         |  54%  124 MB
|=================================================                                         |  54%  124 MB
|=================================================                                         |  54%  124 MB
|=================================================                                         |  54%  124 MB
|=================================================                                         |  54%  124 MB
|=================================================                                         |  54%  125 MB
|=================================================                                         |  54%  125 MB
|=================================================                                         |  54%  125 MB
|=================================================                                         |  54%  125 MB
|=================================================                                         |  54%  125 MB
|=================================================                                         |  54%  125 MB
|=================================================                                         |  54%  125 MB
|==================================================                                        |  54%  126 MB
|==================================================                                        |  55%  126 MB
|==================================================                                        |  55%  126 MB
|==================================================                                        |  55%  126 MB
|==================================================                                        |  55%  126 MB
|==================================================                                        |  55%  126 MB
|==================================================                                        |  55%  126 MB
|==================================================                                        |  55%  126 MB
|==================================================                                        |  55%  127 MB
|==================================================                                        |  55%  127 MB
|==================================================                                        |  55%  127 MB
|==================================================                                        |  55%  127 MB
|==================================================                                        |  55%  127 MB
|==================================================                                        |  55%  127 MB
|==================================================                                        |  55%  127 MB
|==================================================                                        |  55%  127 MB
|==================================================                                        |  55%  128 MB
|==================================================                                        |  55%  128 MB
|==================================================                                        |  55%  128 MB
|==================================================                                        |  56%  128 MB
|===================================================                                       |  56%  128 MB
|===================================================                                       |  56%  128 MB
|===================================================                                       |  56%  128 MB
|===================================================                                       |  56%  128 MB
|===================================================                                       |  56%  129 MB
|===================================================                                       |  56%  129 MB
|===================================================                                       |  56%  129 MB
|===================================================                                       |  56%  129 MB
|===================================================                                       |  56%  129 MB
|===================================================                                       |  56%  129 MB
|===================================================                                       |  56%  129 MB
|===================================================                                       |  56%  129 MB
|===================================================                                       |  56%  130 MB
|===================================================                                       |  56%  130 MB
|===================================================                                       |  56%  130 MB
|===================================================                                       |  56%  130 MB
|===================================================                                       |  56%  130 MB
|===================================================                                       |  57%  130 MB
|===================================================                                       |  57%  130 MB
|===================================================                                       |  57%  130 MB
|====================================================                                      |  57%  131 MB
|====================================================                                      |  57%  131 MB
|====================================================                                      |  57%  131 MB
|====================================================                                      |  57%  131 MB
|====================================================                                      |  57%  131 MB
|====================================================                                      |  57%  131 MB
|====================================================                                      |  57%  131 MB
|====================================================                                      |  57%  131 MB
|====================================================                                      |  57%  132 MB
|====================================================                                      |  57%  132 MB
|====================================================                                      |  57%  132 MB
|====================================================                                      |  57%  132 MB
|====================================================                                      |  57%  132 MB
|====================================================                                      |  57%  132 MB
|====================================================                                      |  57%  132 MB
|====================================================                                      |  58%  132 MB
|====================================================                                      |  58%  133 MB
|====================================================                                      |  58%  133 MB
|====================================================                                      |  58%  133 MB
|====================================================                                      |  58%  133 MB
|=====================================================                                     |  58%  133 MB
|=====================================================                                     |  58%  133 MB
|=====================================================                                     |  58%  133 MB
|=====================================================                                     |  58%  133 MB
|=====================================================                                     |  58%  134 MB
|=====================================================                                     |  58%  134 MB
|=====================================================                                     |  58%  134 MB
|=====================================================                                     |  58%  134 MB
|=====================================================                                     |  58%  134 MB
|=====================================================                                     |  58%  134 MB
|=====================================================                                     |  58%  134 MB
|=====================================================                                     |  58%  134 MB
|=====================================================                                     |  58%  135 MB
|=====================================================                                     |  58%  135 MB
|=====================================================                                     |  59%  135 MB
|=====================================================                                     |  59%  135 MB
|=====================================================                                     |  59%  135 MB
|=====================================================                                     |  59%  135 MB
|=====================================================                                     |  59%  135 MB
|=====================================================                                     |  59%  135 MB
|======================================================                                    |  59%  136 MB
|======================================================                                    |  59%  136 MB
|======================================================                                    |  59%  136 MB
|======================================================                                    |  59%  136 MB
|======================================================                                    |  59%  136 MB
|======================================================                                    |  59%  136 MB
|======================================================                                    |  59%  136 MB
|======================================================                                    |  59%  136 MB
|======================================================                                    |  59%  137 MB
|======================================================                                    |  59%  137 MB
|======================================================                                    |  59%  137 MB
|======================================================                                    |  59%  137 MB
|======================================================                                    |  60%  137 MB
|======================================================                                    |  60%  137 MB
|======================================================                                    |  60%  137 MB
|======================================================                                    |  60%  137 MB
|======================================================                                    |  60%  138 MB
|======================================================                                    |  60%  138 MB
|======================================================                                    |  60%  138 MB
|======================================================                                    |  60%  138 MB
|=======================================================                                   |  60%  138 MB
|=======================================================                                   |  60%  138 MB
|=======================================================                                   |  60%  138 MB
|=======================================================                                   |  60%  138 MB
|=======================================================                                   |  60%  139 MB
|=======================================================                                   |  60%  139 MB
|=======================================================                                   |  60%  139 MB
|=======================================================                                   |  60%  139 MB
|=======================================================                                   |  60%  139 MB
|=======================================================                                   |  60%  139 MB
|=======================================================                                   |  61%  139 MB
|=======================================================                                   |  61%  139 MB
|=======================================================                                   |  61%  140 MB
|=======================================================                                   |  61%  140 MB
|=======================================================                                   |  61%  140 MB
|=======================================================                                   |  61%  140 MB
|=======================================================                                   |  61%  140 MB
|=======================================================                                   |  61%  140 MB
|=======================================================                                   |  61%  140 MB
|=======================================================                                   |  61%  140 MB
|========================================================                                  |  61%  141 MB
|========================================================                                  |  61%  141 MB
|========================================================                                  |  61%  141 MB
|========================================================                                  |  61%  141 MB
|========================================================                                  |  61%  141 MB
|========================================================                                  |  61%  141 MB
|========================================================                                  |  61%  141 MB
|========================================================                                  |  61%  141 MB
|========================================================                                  |  62%  142 MB
|========================================================                                  |  62%  142 MB
|========================================================                                  |  62%  142 MB
|========================================================                                  |  62%  142 MB
|========================================================                                  |  62%  142 MB
|========================================================                                  |  62%  142 MB
|========================================================                                  |  62%  142 MB
|========================================================                                  |  62%  142 MB
|========================================================                                  |  62%  143 MB
|========================================================                                  |  62%  143 MB
|========================================================                                  |  62%  143 MB
|========================================================                                  |  62%  143 MB
|=========================================================                                 |  62%  143 MB
|=========================================================                                 |  62%  143 MB
|=========================================================                                 |  62%  143 MB
|=========================================================                                 |  62%  143 MB
|=========================================================                                 |  62%  144 MB
|=========================================================                                 |  62%  144 MB
|=========================================================                                 |  63%  144 MB
|=========================================================                                 |  63%  144 MB
|=========================================================                                 |  63%  144 MB
|=========================================================                                 |  63%  144 MB
|=========================================================                                 |  63%  144 MB
|=========================================================                                 |  63%  144 MB
|=========================================================                                 |  63%  145 MB
|=========================================================                                 |  63%  145 MB
|=========================================================                                 |  63%  145 MB
|=========================================================                                 |  63%  145 MB
|=========================================================                                 |  63%  145 MB
|=========================================================                                 |  63%  145 MB
|=========================================================                                 |  63%  145 MB
|=========================================================                                 |  63%  145 MB
|==========================================================                                |  63%  146 MB
|==========================================================                                |  63%  146 MB
|==========================================================                                |  63%  146 MB
|==========================================================                                |  63%  146 MB
|==========================================================                                |  63%  146 MB
|==========================================================                                |  64%  146 MB
|==========================================================                                |  64%  146 MB
|==========================================================                                |  64%  146 MB
|==========================================================                                |  64%  147 MB
|==========================================================                                |  64%  147 MB
|==========================================================                                |  64%  147 MB
|==========================================================                                |  64%  147 MB
|==========================================================                                |  64%  147 MB
|==========================================================                                |  64%  147 MB
|==========================================================                                |  64%  147 MB
|==========================================================                                |  64%  147 MB
|==========================================================                                |  64%  148 MB
|==========================================================                                |  64%  148 MB
|==========================================================                                |  64%  148 MB
|==========================================================                                |  64%  148 MB
|===========================================================                               |  64%  148 MB
|===========================================================                               |  64%  148 MB
|===========================================================                               |  64%  148 MB
|===========================================================                               |  65%  149 MB
|===========================================================                               |  65%  149 MB
|===========================================================                               |  65%  149 MB
|===========================================================                               |  65%  149 MB
|===========================================================                               |  65%  149 MB
|===========================================================                               |  65%  149 MB
|===========================================================                               |  65%  149 MB
|===========================================================                               |  65%  149 MB
|===========================================================                               |  65%  150 MB
|===========================================================                               |  65%  150 MB
|===========================================================                               |  65%  150 MB
|===========================================================                               |  65%  150 MB
|===========================================================                               |  65%  150 MB
|===========================================================                               |  65%  150 MB
|===========================================================                               |  65%  150 MB
|===========================================================                               |  65%  150 MB
|===========================================================                               |  65%  151 MB
|============================================================                              |  65%  151 MB
|============================================================                              |  66%  151 MB
|============================================================                              |  66%  151 MB
|============================================================                              |  66%  151 MB
|============================================================                              |  66%  151 MB
|============================================================                              |  66%  151 MB
|============================================================                              |  66%  151 MB
|============================================================                              |  66%  152 MB
|============================================================                              |  66%  152 MB
|============================================================                              |  66%  152 MB
|============================================================                              |  66%  152 MB
|============================================================                              |  66%  152 MB
|============================================================                              |  66%  152 MB
|============================================================                              |  66%  152 MB
|============================================================                              |  66%  152 MB
|============================================================                              |  66%  153 MB
|============================================================                              |  66%  153 MB
|============================================================                              |  66%  153 MB
|============================================================                              |  66%  153 MB
|============================================================                              |  67%  153 MB
|=============================================================                             |  67%  153 MB
|=============================================================                             |  67%  153 MB
|=============================================================                             |  67%  153 MB
|=============================================================                             |  67%  154 MB
|=============================================================                             |  67%  154 MB
|=============================================================                             |  67%  154 MB
|=============================================================                             |  67%  154 MB
|=============================================================                             |  67%  154 MB
|=============================================================                             |  67%  154 MB
|=============================================================                             |  67%  154 MB
|=============================================================                             |  67%  154 MB
|=============================================================                             |  67%  155 MB
|=============================================================                             |  67%  155 MB
|=============================================================                             |  67%  155 MB
|=============================================================                             |  67%  155 MB
|=============================================================                             |  67%  155 MB
|=============================================================                             |  67%  155 MB
|=============================================================                             |  68%  155 MB
|=============================================================                             |  68%  155 MB
|=============================================================                             |  68%  156 MB
|==============================================================                            |  68%  156 MB
|==============================================================                            |  68%  156 MB
|==============================================================                            |  68%  156 MB
|==============================================================                            |  68%  156 MB
|==============================================================                            |  68%  156 MB
|==============================================================                            |  68%  156 MB
|==============================================================                            |  68%  156 MB
|==============================================================                            |  68%  157 MB
|==============================================================                            |  68%  157 MB
|==============================================================                            |  68%  157 MB
|==============================================================                            |  68%  157 MB
|==============================================================                            |  68%  157 MB
|==============================================================                            |  68%  157 MB
|==============================================================                            |  68%  157 MB
|==============================================================                            |  68%  157 MB
|==============================================================                            |  68%  158 MB
|==============================================================                            |  69%  158 MB
|==============================================================                            |  69%  158 MB
|==============================================================                            |  69%  158 MB
|==============================================================                            |  69%  158 MB
|===============================================================                           |  69%  158 MB
|===============================================================                           |  69%  158 MB
|===============================================================                           |  69%  158 MB
|===============================================================                           |  69%  159 MB
|===============================================================                           |  69%  159 MB
|===============================================================                           |  69%  159 MB
|===============================================================                           |  69%  159 MB
|===============================================================                           |  69%  159 MB
|===============================================================                           |  69%  159 MB
|===============================================================                           |  69%  159 MB
|===============================================================                           |  69%  159 MB
|===============================================================                           |  69%  160 MB
|===============================================================                           |  69%  160 MB
|===============================================================                           |  69%  160 MB
|===============================================================                           |  70%  160 MB
|===============================================================                           |  70%  160 MB
|===============================================================                           |  70%  160 MB
|===============================================================                           |  70%  160 MB
|===============================================================                           |  70%  160 MB
|===============================================================                           |  70%  161 MB
|================================================================                          |  70%  161 MB
|================================================================                          |  70%  161 MB
|================================================================                          |  70%  161 MB
|================================================================                          |  70%  161 MB
|================================================================                          |  70%  161 MB
|================================================================                          |  70%  161 MB
|================================================================                          |  70%  161 MB
|================================================================                          |  70%  162 MB
|================================================================                          |  70%  162 MB
|================================================================                          |  70%  162 MB
|================================================================                          |  70%  162 MB
|================================================================                          |  70%  162 MB
|================================================================                          |  71%  162 MB
|================================================================                          |  71%  162 MB
|================================================================                          |  71%  162 MB
|================================================================                          |  71%  163 MB
|================================================================                          |  71%  163 MB
|================================================================                          |  71%  163 MB
|================================================================                          |  71%  163 MB
|================================================================                          |  71%  163 MB
|=================================================================                         |  71%  163 MB
|=================================================================                         |  71%  163 MB
|=================================================================                         |  71%  163 MB
|=================================================================                         |  71%  164 MB
|=================================================================                         |  71%  164 MB
|=================================================================                         |  71%  164 MB
|=================================================================                         |  71%  164 MB
|=================================================================                         |  71%  164 MB
|=================================================================                         |  71%  164 MB
|=================================================================                         |  71%  164 MB
|=================================================================                         |  72%  164 MB
|=================================================================                         |  72%  165 MB
|=================================================================                         |  72%  165 MB
|=================================================================                         |  72%  165 MB
|=================================================================                         |  72%  165 MB
|=================================================================                         |  72%  165 MB
|=================================================================                         |  72%  165 MB
|=================================================================                         |  72%  165 MB
|=================================================================                         |  72%  165 MB
|=================================================================                         |  72%  166 MB
|==================================================================                        |  72%  166 MB
|==================================================================                        |  72%  166 MB
|==================================================================                        |  72%  166 MB
|==================================================================                        |  72%  166 MB
|==================================================================                        |  72%  166 MB
|==================================================================                        |  72%  166 MB
|==================================================================                        |  72%  166 MB
|==================================================================                        |  72%  167 MB
|==================================================================                        |  72%  167 MB
|==================================================================                        |  73%  167 MB
|==================================================================                        |  73%  167 MB
|==================================================================                        |  73%  167 MB
|==================================================================                        |  73%  167 MB
|==================================================================                        |  73%  167 MB
|==================================================================                        |  73%  167 MB
|==================================================================                        |  73%  168 MB
|==================================================================                        |  73%  168 MB
|==================================================================                        |  73%  168 MB
|==================================================================                        |  73%  168 MB
|==================================================================                        |  73%  168 MB
|===================================================================                       |  73%  168 MB
|===================================================================                       |  73%  168 MB
|===================================================================                       |  73%  168 MB
|===================================================================                       |  73%  169 MB
|===================================================================                       |  73%  169 MB
|===================================================================                       |  73%  169 MB
|===================================================================                       |  73%  169 MB
|===================================================================                       |  74%  169 MB
|===================================================================                       |  74%  169 MB
|===================================================================                       |  74%  169 MB
|===================================================================                       |  74%  170 MB
|===================================================================                       |  74%  170 MB
|===================================================================                       |  74%  170 MB
|===================================================================                       |  74%  170 MB
|===================================================================                       |  74%  170 MB
|===================================================================                       |  74%  170 MB
|===================================================================                       |  74%  170 MB
|===================================================================                       |  74%  170 MB
|===================================================================                       |  74%  171 MB
|===================================================================                       |  74%  171 MB
|====================================================================                      |  74%  171 MB
|====================================================================                      |  74%  171 MB
|====================================================================                      |  74%  171 MB
|====================================================================                      |  74%  171 MB
|====================================================================                      |  74%  171 MB
|====================================================================                      |  75%  171 MB
|====================================================================                      |  75%  172 MB
|====================================================================                      |  75%  172 MB
|====================================================================                      |  75%  172 MB
|====================================================================                      |  75%  172 MB
|====================================================================                      |  75%  172 MB
|====================================================================                      |  75%  172 MB
|====================================================================                      |  75%  172 MB
|====================================================================                      |  75%  172 MB
|====================================================================                      |  75%  173 MB
|====================================================================                      |  75%  173 MB
|====================================================================                      |  75%  173 MB
|====================================================================                      |  75%  173 MB
|====================================================================                      |  75%  173 MB
|====================================================================                      |  75%  173 MB
|=====================================================================                     |  75%  173 MB
|=====================================================================                     |  75%  173 MB
|=====================================================================                     |  75%  174 MB
|=====================================================================                     |  76%  174 MB
|=====================================================================                     |  76%  174 MB
|=====================================================================                     |  76%  174 MB
|=====================================================================                     |  76%  174 MB
|=====================================================================                     |  76%  174 MB
|=====================================================================                     |  76%  174 MB
|=====================================================================                     |  76%  174 MB
|=====================================================================                     |  76%  175 MB
|=====================================================================                     |  76%  175 MB
|=====================================================================                     |  76%  175 MB
|=====================================================================                     |  76%  175 MB
|=====================================================================                     |  76%  175 MB
|=====================================================================                     |  76%  175 MB
|=====================================================================                     |  76%  175 MB
|=====================================================================                     |  76%  175 MB
|=====================================================================                     |  76%  176 MB
|=====================================================================                     |  76%  176 MB
|======================================================================                    |  76%  176 MB
|======================================================================                    |  76%  176 MB
|======================================================================                    |  77%  176 MB
|======================================================================                    |  77%  176 MB
|======================================================================                    |  77%  176 MB
|======================================================================                    |  77%  176 MB
|======================================================================                    |  77%  177 MB
|======================================================================                    |  77%  177 MB
|======================================================================                    |  77%  177 MB
|======================================================================                    |  77%  177 MB
|======================================================================                    |  77%  177 MB
|======================================================================                    |  77%  177 MB
|======================================================================                    |  77%  177 MB
|======================================================================                    |  77%  177 MB
|======================================================================                    |  77%  178 MB
|======================================================================                    |  77%  178 MB
|======================================================================                    |  77%  178 MB
|======================================================================                    |  77%  178 MB
|======================================================================                    |  77%  178 MB
|======================================================================                    |  77%  178 MB
|=======================================================================                   |  78%  178 MB
|=======================================================================                   |  78%  178 MB
|=======================================================================                   |  78%  179 MB
|=======================================================================                   |  78%  179 MB
|=======================================================================                   |  78%  179 MB
|=======================================================================                   |  78%  179 MB
|=======================================================================                   |  78%  179 MB
|=======================================================================                   |  78%  179 MB
|=======================================================================                   |  78%  179 MB
|=======================================================================                   |  78%  179 MB
|=======================================================================                   |  78%  180 MB
|=======================================================================                   |  78%  180 MB
|=======================================================================                   |  78%  180 MB
|=======================================================================                   |  78%  180 MB
|=======================================================================                   |  78%  180 MB
|=======================================================================                   |  78%  180 MB
|=======================================================================                   |  78%  180 MB
|=======================================================================                   |  78%  180 MB
|=======================================================================                   |  79%  181 MB
|=======================================================================                   |  79%  181 MB
|========================================================================                  |  79%  181 MB
|========================================================================                  |  79%  181 MB
|========================================================================                  |  79%  181 MB
|========================================================================                  |  79%  181 MB
|========================================================================                  |  79%  181 MB
|========================================================================                  |  79%  181 MB
|========================================================================                  |  79%  182 MB
|========================================================================                  |  79%  182 MB
|========================================================================                  |  79%  182 MB
|========================================================================                  |  79%  182 MB
|========================================================================                  |  79%  182 MB
|========================================================================                  |  79%  182 MB
|========================================================================                  |  79%  182 MB
|========================================================================                  |  79%  182 MB
|========================================================================                  |  79%  183 MB
|========================================================================                  |  79%  183 MB
|========================================================================                  |  80%  183 MB
|========================================================================                  |  80%  183 MB
|========================================================================                  |  80%  183 MB
|========================================================================                  |  80%  183 MB
|=========================================================================                 |  80%  183 MB
|=========================================================================                 |  80%  183 MB
|=========================================================================                 |  80%  184 MB
|=========================================================================                 |  80%  184 MB
|=========================================================================                 |  80%  184 MB
|=========================================================================                 |  80%  184 MB
|=========================================================================                 |  80%  184 MB
|=========================================================================                 |  80%  184 MB
|=========================================================================                 |  80%  184 MB
|=========================================================================                 |  80%  184 MB
|=========================================================================                 |  80%  185 MB
|=========================================================================                 |  80%  185 MB
|=========================================================================                 |  80%  185 MB
|=========================================================================                 |  80%  185 MB
|=========================================================================                 |  81%  185 MB
|=========================================================================                 |  81%  185 MB
|=========================================================================                 |  81%  185 MB
|=========================================================================                 |  81%  185 MB
|=========================================================================                 |  81%  186 MB
|=========================================================================                 |  81%  186 MB
|==========================================================================                |  81%  186 MB
|==========================================================================                |  81%  186 MB
|==========================================================================                |  81%  186 MB
|==========================================================================                |  81%  186 MB
|==========================================================================                |  81%  186 MB
|==========================================================================                |  81%  186 MB
|==========================================================================                |  81%  187 MB
|==========================================================================                |  81%  187 MB
|==========================================================================                |  81%  187 MB
|==========================================================================                |  81%  187 MB
|==========================================================================                |  81%  187 MB
|==========================================================================                |  81%  187 MB
|==========================================================================                |  81%  187 MB
|==========================================================================                |  82%  187 MB
|==========================================================================                |  82%  188 MB
|==========================================================================                |  82%  188 MB
|==========================================================================                |  82%  188 MB
|==========================================================================                |  82%  188 MB
|==========================================================================                |  82%  188 MB
|==========================================================================                |  82%  188 MB
|===========================================================================               |  82%  188 MB
|===========================================================================               |  82%  188 MB
|===========================================================================               |  82%  189 MB
|===========================================================================               |  82%  189 MB
|===========================================================================               |  82%  189 MB
|===========================================================================               |  82%  189 MB
|===========================================================================               |  82%  189 MB
|===========================================================================               |  82%  189 MB
|===========================================================================               |  82%  189 MB
|===========================================================================               |  82%  190 MB
|===========================================================================               |  82%  190 MB
|===========================================================================               |  83%  190 MB
|===========================================================================               |  83%  190 MB
|===========================================================================               |  83%  190 MB
|===========================================================================               |  83%  190 MB
|===========================================================================               |  83%  190 MB
|===========================================================================               |  83%  190 MB
|===========================================================================               |  83%  191 MB
|===========================================================================               |  83%  191 MB
|===========================================================================               |  83%  191 MB
|============================================================================              |  83%  191 MB
|============================================================================              |  83%  191 MB
|============================================================================              |  83%  191 MB
|============================================================================              |  83%  191 MB
|============================================================================              |  83%  191 MB
|============================================================================              |  83%  192 MB
|============================================================================              |  83%  192 MB
|============================================================================              |  83%  192 MB
|============================================================================              |  83%  192 MB
|============================================================================              |  84%  192 MB
|============================================================================              |  84%  192 MB
|============================================================================              |  84%  192 MB
|============================================================================              |  84%  192 MB
|============================================================================              |  84%  193 MB
|============================================================================              |  84%  193 MB
|============================================================================              |  84%  193 MB
|============================================================================              |  84%  193 MB
|============================================================================              |  84%  193 MB
|============================================================================              |  84%  193 MB
|============================================================================              |  84%  193 MB
|=============================================================================             |  84%  193 MB
|=============================================================================             |  84%  194 MB
|=============================================================================             |  84%  194 MB
|=============================================================================             |  84%  194 MB
|=============================================================================             |  84%  194 MB
|=============================================================================             |  84%  194 MB
|=============================================================================             |  84%  194 MB
|=============================================================================             |  85%  194 MB
|=============================================================================             |  85%  194 MB
|=============================================================================             |  85%  195 MB
|=============================================================================             |  85%  195 MB
|=============================================================================             |  85%  195 MB
|=============================================================================             |  85%  195 MB
|=============================================================================             |  85%  195 MB
|=============================================================================             |  85%  195 MB
|=============================================================================             |  85%  195 MB
|=============================================================================             |  85%  195 MB
|=============================================================================             |  85%  196 MB
|=============================================================================             |  85%  196 MB
|=============================================================================             |  85%  196 MB
|==============================================================================            |  85%  196 MB
|==============================================================================            |  85%  196 MB
|==============================================================================            |  85%  196 MB
|==============================================================================            |  85%  196 MB
|==============================================================================            |  85%  196 MB
|==============================================================================            |  86%  197 MB
|==============================================================================            |  86%  197 MB
|==============================================================================            |  86%  197 MB
|==============================================================================            |  86%  197 MB
|==============================================================================            |  86%  197 MB
|==============================================================================            |  86%  197 MB
|==============================================================================            |  86%  197 MB
|==============================================================================            |  86%  197 MB
|==============================================================================            |  86%  198 MB
|==============================================================================            |  86%  198 MB
|==============================================================================            |  86%  198 MB
|==============================================================================            |  86%  198 MB
|==============================================================================            |  86%  198 MB
|==============================================================================            |  86%  198 MB
|==============================================================================            |  86%  198 MB
|===============================================================================           |  86%  199 MB
|===============================================================================           |  86%  199 MB
|===============================================================================           |  86%  199 MB
|===============================================================================           |  87%  199 MB
|===============================================================================           |  87%  199 MB
|===============================================================================           |  87%  199 MB
|===============================================================================           |  87%  199 MB
|===============================================================================           |  87%  199 MB
|===============================================================================           |  87%  200 MB
|===============================================================================           |  87%  200 MB
|===============================================================================           |  87%  200 MB
|===============================================================================           |  87%  200 MB
|===============================================================================           |  87%  200 MB
|===============================================================================           |  87%  200 MB
|===============================================================================           |  87%  200 MB
|===============================================================================           |  87%  200 MB
|===============================================================================           |  87%  201 MB
|===============================================================================           |  87%  201 MB
|===============================================================================           |  87%  201 MB
|================================================================================          |  87%  201 MB
|================================================================================          |  87%  201 MB
|================================================================================          |  88%  201 MB
|================================================================================          |  88%  201 MB
|================================================================================          |  88%  201 MB
|================================================================================          |  88%  202 MB
|================================================================================          |  88%  202 MB
|================================================================================          |  88%  202 MB
|================================================================================          |  88%  202 MB
|================================================================================          |  88%  202 MB
|================================================================================          |  88%  202 MB
|================================================================================          |  88%  202 MB
|================================================================================          |  88%  202 MB
|================================================================================          |  88%  203 MB
|================================================================================          |  88%  203 MB
|================================================================================          |  88%  203 MB
|================================================================================          |  88%  203 MB
|================================================================================          |  88%  203 MB
|================================================================================          |  88%  203 MB
|================================================================================          |  88%  203 MB
|=================================================================================         |  89%  203 MB
|=================================================================================         |  89%  204 MB
|=================================================================================         |  89%  204 MB
|=================================================================================         |  89%  204 MB
|=================================================================================         |  89%  204 MB
|=================================================================================         |  89%  204 MB
|=================================================================================         |  89%  204 MB
|=================================================================================         |  89%  204 MB
|=================================================================================         |  89%  204 MB
|=================================================================================         |  89%  205 MB
|=================================================================================         |  89%  205 MB
|=================================================================================         |  89%  205 MB
|=================================================================================         |  89%  205 MB
|=================================================================================         |  89%  205 MB
|=================================================================================         |  89%  205 MB
|=================================================================================         |  89%  205 MB
|=================================================================================         |  89%  205 MB
|=================================================================================         |  89%  206 MB
|=================================================================================         |  90%  206 MB
|=================================================================================         |  90%  206 MB
|==================================================================================        |  90%  206 MB
|==================================================================================        |  90%  206 MB
|==================================================================================        |  90%  206 MB
|==================================================================================        |  90%  206 MB
|==================================================================================        |  90%  207 MB
|==================================================================================        |  90%  207 MB
|==================================================================================        |  90%  207 MB
|==================================================================================        |  90%  207 MB
|==================================================================================        |  90%  207 MB
|==================================================================================        |  90%  207 MB
|==================================================================================        |  90%  207 MB
|==================================================================================        |  90%  207 MB
|==================================================================================        |  90%  208 MB
|==================================================================================        |  90%  208 MB
|==================================================================================        |  90%  208 MB
|==================================================================================        |  90%  208 MB
|==================================================================================        |  91%  208 MB
|==================================================================================        |  91%  208 MB
|==================================================================================        |  91%  208 MB
|==================================================================================        |  91%  208 MB
|===================================================================================       |  91%  209 MB
|===================================================================================       |  91%  209 MB
|===================================================================================       |  91%  209 MB
|===================================================================================       |  91%  209 MB
|===================================================================================       |  91%  209 MB
|===================================================================================       |  91%  209 MB
|===================================================================================       |  91%  209 MB
|===================================================================================       |  91%  209 MB
|===================================================================================       |  91%  210 MB
|===================================================================================       |  91%  210 MB
|===================================================================================       |  91%  210 MB
|===================================================================================       |  91%  210 MB
|===================================================================================       |  91%  210 MB
|===================================================================================       |  91%  210 MB
|===================================================================================       |  92%  210 MB
|===================================================================================       |  92%  210 MB
|===================================================================================       |  92%  211 MB
|===================================================================================       |  92%  211 MB
|===================================================================================       |  92%  211 MB
|===================================================================================       |  92%  211 MB
|====================================================================================      |  92%  211 MB
|====================================================================================      |  92%  211 MB
|====================================================================================      |  92%  211 MB
|====================================================================================      |  92%  211 MB
|====================================================================================      |  92%  212 MB
|====================================================================================      |  92%  212 MB
|====================================================================================      |  92%  212 MB
|====================================================================================      |  92%  212 MB
|====================================================================================      |  92%  212 MB
|====================================================================================      |  92%  212 MB
|====================================================================================      |  92%  212 MB
|====================================================================================      |  92%  212 MB
|====================================================================================      |  93%  213 MB
|====================================================================================      |  93%  213 MB
|====================================================================================      |  93%  213 MB
|====================================================================================      |  93%  213 MB
|====================================================================================      |  93%  213 MB
|====================================================================================      |  93%  213 MB
|====================================================================================      |  93%  213 MB
|====================================================================================      |  93%  213 MB
|=====================================================================================     |  93%  214 MB
|=====================================================================================     |  93%  214 MB
|=====================================================================================     |  93%  214 MB
|=====================================================================================     |  93%  214 MB
|=====================================================================================     |  93%  214 MB
|=====================================================================================     |  93%  214 MB
|=====================================================================================     |  93%  214 MB
|=====================================================================================     |  93%  214 MB
|=====================================================================================     |  93%  215 MB
|=====================================================================================     |  93%  215 MB
|=====================================================================================     |  93%  215 MB
|=====================================================================================     |  94%  215 MB
|=====================================================================================     |  94%  215 MB
|=====================================================================================     |  94%  215 MB
|=====================================================================================     |  94%  215 MB
|=====================================================================================     |  94%  215 MB
|=====================================================================================     |  94%  216 MB
|=====================================================================================     |  94%  216 MB
|=====================================================================================     |  94%  216 MB
|=====================================================================================     |  94%  216 MB
|======================================================================================    |  94%  216 MB
|======================================================================================    |  94%  216 MB
|======================================================================================    |  94%  216 MB
|======================================================================================    |  94%  217 MB
|======================================================================================    |  94%  217 MB
|======================================================================================    |  94%  217 MB
|======================================================================================    |  94%  217 MB
|======================================================================================    |  94%  217 MB
|======================================================================================    |  94%  217 MB
|======================================================================================    |  95%  217 MB
|======================================================================================    |  95%  217 MB
|======================================================================================    |  95%  218 MB
|======================================================================================    |  95%  218 MB
|======================================================================================    |  95%  218 MB
|======================================================================================    |  95%  218 MB
|======================================================================================    |  95%  218 MB
|======================================================================================    |  95%  218 MB
|======================================================================================    |  95%  218 MB
|======================================================================================    |  95%  218 MB
|======================================================================================    |  95%  219 MB
|=======================================================================================   |  95%  219 MB
|=======================================================================================   |  95%  219 MB
|=======================================================================================   |  95%  219 MB
|=======================================================================================   |  95%  219 MB
|=======================================================================================   |  95%  219 MB
|=======================================================================================   |  95%  219 MB
|=======================================================================================   |  95%  219 MB
|=======================================================================================   |  96%  220 MB
|=======================================================================================   |  96%  220 MB
|=======================================================================================   |  96%  220 MB
|=======================================================================================   |  96%  220 MB
|=======================================================================================   |  96%  220 MB
|=======================================================================================   |  96%  220 MB
|=======================================================================================   |  96%  220 MB
|=======================================================================================   |  96%  220 MB
|=======================================================================================   |  96%  221 MB
|=======================================================================================   |  96%  221 MB
|=======================================================================================   |  96%  221 MB
|=======================================================================================   |  96%  221 MB
|========================================================================================  |  96%  221 MB
|========================================================================================  |  96%  221 MB
|========================================================================================  |  96%  221 MB
|========================================================================================  |  96%  221 MB
|========================================================================================  |  96%  222 MB
|========================================================================================  |  96%  222 MB
|========================================================================================  |  97%  222 MB
|========================================================================================  |  97%  222 MB
|========================================================================================  |  97%  222 MB
|========================================================================================  |  97%  222 MB
|========================================================================================  |  97%  222 MB
|========================================================================================  |  97%  222 MB
|========================================================================================  |  97%  223 MB
|========================================================================================  |  97%  223 MB
|========================================================================================  |  97%  223 MB
|========================================================================================  |  97%  223 MB
|========================================================================================  |  97%  223 MB
|========================================================================================  |  97%  223 MB
|========================================================================================  |  97%  223 MB
|========================================================================================  |  97%  223 MB
|========================================================================================= |  97%  224 MB
|========================================================================================= |  97%  224 MB
|========================================================================================= |  97%  224 MB
|========================================================================================= |  97%  224 MB
|========================================================================================= |  98%  224 MB
|========================================================================================= |  98%  224 MB
|========================================================================================= |  98%  224 MB
|========================================================================================= |  98%  224 MB
|========================================================================================= |  98%  225 MB
|========================================================================================= |  98%  225 MB
|========================================================================================= |  98%  225 MB
|========================================================================================= |  98%  225 MB
|========================================================================================= |  98%  225 MB
|========================================================================================= |  98%  225 MB
|========================================================================================= |  98%  225 MB
|========================================================================================= |  98%  226 MB
|========================================================================================= |  98%  226 MB
|========================================================================================= |  98%  226 MB
|========================================================================================= |  98%  226 MB
|========================================================================================= |  98%  226 MB
|==========================================================================================|  98%  226 MB
|==========================================================================================|  98%  226 MB
|==========================================================================================|  99%  226 MB
|==========================================================================================|  99%  227 MB
|==========================================================================================|  99%  227 MB
|==========================================================================================|  99%  227 MB
|==========================================================================================|  99%  227 MB
|==========================================================================================|  99%  227 MB
|==========================================================================================|  99%  227 MB
|==========================================================================================|  99%  227 MB
|==========================================================================================|  99%  227 MB
|==========================================================================================|  99%  228 MB
|==========================================================================================|  99%  228 MB
|==========================================================================================|  99%  228 MB
|==========================================================================================|  99%  228 MB
|==========================================================================================|  99%  228 MB
|==========================================================================================|  99%  228 MB
|==========================================================================================|  99%  228 MB
|==========================================================================================|  99%  228 MB
|==========================================================================================|  99%  229 MB
|===========================================================================================| 100%  229 MB
crime_12062016_to_03192018 <- 
  read_csv("./data/DPD__All_Crime_Incidents__December_6__2016_-_3_19_2018.csv", 
           guess_max = 10^6)
Parsed with column specification:
cols(
  .default = col_character(),
  `Crime ID` = col_integer(),
  `Day of Week (Sunday is 1)` = col_integer(),
  `Hour of Day` = col_integer(),
  Year = col_integer(),
  `Census Block GEOID` = col_double(),
  `Council District` = col_integer(),
  `Zip Code` = col_integer(),
  Longitude = col_double(),
  Latitude = col_double(),
  uniq = col_integer()
)
See spec(...) for full column specifications.

|=                                                                                                 |   1%
|=                                                                                                 |   1%
|==                                                                                                |   2%
|==                                                                                                |   2%
|==                                                                                                |   2%
|===                                                                                       |   3%    1 MB
|===                                                                                       |   3%    1 MB
|===                                                                                       |   4%    1 MB
|====                                                                                      |   4%    1 MB
|====                                                                                      |   5%    1 MB
|====                                                                                      |   5%    1 MB
|=====                                                                                     |   5%    1 MB
|=====                                                                                     |   6%    1 MB
|======                                                                                    |   6%    2 MB
|======                                                                                    |   7%    2 MB
|======                                                                                    |   7%    2 MB
|=======                                                                                   |   7%    2 MB
|=======                                                                                   |   8%    2 MB
|=======                                                                                   |   8%    2 MB
|========                                                                                  |   9%    2 MB
|========                                                                                  |   9%    2 MB
|========                                                                                  |   9%    3 MB
|=========                                                                                 |  10%    3 MB
|=========                                                                                 |  10%    3 MB
|==========                                                                                |  11%    3 MB
|==========                                                                                |  11%    3 MB
|==========                                                                                |  11%    3 MB
|===========                                                                               |  12%    3 MB
|===========                                                                               |  12%    3 MB
|===========                                                                               |  13%    4 MB
|============                                                                              |  13%    4 MB
|============                                                                              |  13%    4 MB
|=============                                                                             |  14%    4 MB
|=============                                                                             |  14%    4 MB
|=============                                                                             |  15%    4 MB
|==============                                                                            |  15%    4 MB
|==============                                                                            |  15%    4 MB
|==============                                                                            |  16%    5 MB
|===============                                                                           |  16%    5 MB
|===============                                                                           |  17%    5 MB
|===============                                                                           |  17%    5 MB
|================                                                                          |  17%    5 MB
|================                                                                          |  18%    5 MB
|=================                                                                         |  18%    5 MB
|=================                                                                         |  19%    5 MB
|=================                                                                         |  19%    6 MB
|==================                                                                        |  19%    6 MB
|==================                                                                        |  20%    6 MB
|==================                                                                        |  20%    6 MB
|===================                                                                       |  21%    6 MB
|===================                                                                       |  21%    6 MB
|====================                                                                      |  22%    6 MB
|====================                                                                      |  22%    6 MB
|====================                                                                      |  22%    7 MB
|=====================                                                                     |  23%    7 MB
|=====================                                                                     |  23%    7 MB
|=====================                                                                     |  24%    7 MB
|======================                                                                    |  24%    7 MB
|======================                                                                    |  24%    7 MB
|======================                                                                    |  25%    7 MB
|=======================                                                                   |  25%    7 MB
|=======================                                                                   |  26%    8 MB
|========================                                                                  |  26%    8 MB
|========================                                                                  |  26%    8 MB
|========================                                                                  |  27%    8 MB
|=========================                                                                 |  27%    8 MB
|=========================                                                                 |  28%    8 MB
|=========================                                                                 |  28%    8 MB
|==========================                                                                |  28%    8 MB
|==========================                                                                |  29%    9 MB
|===========================                                                               |  29%    9 MB
|===========================                                                               |  30%    9 MB
|===========================                                                               |  30%    9 MB
|============================                                                              |  30%    9 MB
|============================                                                              |  31%    9 MB
|============================                                                              |  31%    9 MB
|=============================                                                             |  32%    9 MB
|=============================                                                             |  32%   10 MB
|==============================                                                            |  32%   10 MB
|==============================                                                            |  33%   10 MB
|==============================                                                            |  33%   10 MB
|===============================                                                           |  34%   10 MB
|===============================                                                           |  34%   10 MB
|===============================                                                           |  35%   10 MB
|================================                                                          |  35%   10 MB
|================================                                                          |  35%   11 MB
|================================                                                          |  36%   11 MB
|=================================                                                         |  36%   11 MB
|=================================                                                         |  37%   11 MB
|==================================                                                        |  37%   11 MB
|==================================                                                        |  37%   11 MB
|==================================                                                        |  38%   11 MB
|===================================                                                       |  38%   11 MB
|===================================                                                       |  39%   12 MB
|===================================                                                       |  39%   12 MB
|====================================                                                      |  39%   12 MB
|====================================                                                      |  40%   12 MB
|=====================================                                                     |  40%   12 MB
|=====================================                                                     |  41%   12 MB
|=====================================                                                     |  41%   12 MB
|======================================                                                    |  41%   12 MB
|======================================                                                    |  42%   13 MB
|======================================                                                    |  42%   13 MB
|=======================================                                                   |  43%   13 MB
|=======================================                                                   |  43%   13 MB
|========================================                                                  |  43%   13 MB
|========================================                                                  |  44%   13 MB
|========================================                                                  |  44%   13 MB
|=========================================                                                 |  45%   13 MB
|=========================================                                                 |  45%   14 MB
|=========================================                                                 |  45%   14 MB
|==========================================                                                |  46%   14 MB
|==========================================                                                |  46%   14 MB
|==========================================                                                |  47%   14 MB
|===========================================                                               |  47%   14 MB
|===========================================                                               |  48%   14 MB
|============================================                                              |  48%   14 MB
|============================================                                              |  48%   15 MB
|============================================                                              |  49%   15 MB
|=============================================                                             |  49%   15 MB
|=============================================                                             |  50%   15 MB
|=============================================                                             |  50%   15 MB
|==============================================                                            |  50%   15 MB
|==============================================                                            |  51%   15 MB
|===============================================                                           |  51%   15 MB
|===============================================                                           |  52%   16 MB
|===============================================                                           |  52%   16 MB
|================================================                                          |  52%   16 MB
|================================================                                          |  53%   16 MB
|================================================                                          |  53%   16 MB
|=================================================                                         |  54%   16 MB
|=================================================                                         |  54%   16 MB
|=================================================                                         |  54%   16 MB
|==================================================                                        |  55%   17 MB
|==================================================                                        |  55%   17 MB
|===================================================                                       |  56%   17 MB
|===================================================                                       |  56%   17 MB
|===================================================                                       |  56%   17 MB
|====================================================                                      |  57%   17 MB
|====================================================                                      |  57%   17 MB
|====================================================                                      |  58%   18 MB
|=====================================================                                     |  58%   18 MB
|=====================================================                                     |  59%   18 MB
|======================================================                                    |  59%   18 MB
|======================================================                                    |  59%   18 MB
|======================================================                                    |  60%   18 MB
|=======================================================                                   |  60%   18 MB
|=======================================================                                   |  61%   18 MB
|=======================================================                                   |  61%   19 MB
|========================================================                                  |  61%   19 MB
|========================================================                                  |  62%   19 MB
|=========================================================                                 |  62%   19 MB
|=========================================================                                 |  63%   19 MB
|=========================================================                                 |  63%   19 MB
|==========================================================                                |  63%   19 MB
|==========================================================                                |  64%   19 MB
|==========================================================                                |  64%   20 MB
|===========================================================                               |  65%   20 MB
|===========================================================                               |  65%   20 MB
|============================================================                              |  65%   20 MB
|============================================================                              |  66%   20 MB
|============================================================                              |  66%   20 MB
|=============================================================                             |  67%   20 MB
|=============================================================                             |  67%   20 MB
|=============================================================                             |  67%   21 MB
|==============================================================                            |  68%   21 MB
|==============================================================                            |  68%   21 MB
|==============================================================                            |  69%   21 MB
|===============================================================                           |  69%   21 MB
|===============================================================                           |  70%   21 MB
|================================================================                          |  70%   21 MB
|================================================================                          |  70%   21 MB
|================================================================                          |  71%   22 MB
|=================================================================                         |  71%   22 MB
|=================================================================                         |  72%   22 MB
|=================================================================                         |  72%   22 MB
|==================================================================                        |  72%   22 MB
|==================================================================                        |  73%   22 MB
|===================================================================                       |  73%   22 MB
|===================================================================                       |  74%   22 MB
|===================================================================                       |  74%   23 MB
|====================================================================                      |  74%   23 MB
|====================================================================                      |  75%   23 MB
|====================================================================                      |  75%   23 MB
|=====================================================================                     |  76%   23 MB
|=====================================================================                     |  76%   23 MB
|=====================================================================                     |  76%   23 MB
|======================================================================                    |  77%   23 MB
|======================================================================                    |  77%   24 MB
|=======================================================================                   |  78%   24 MB
|=======================================================================                   |  78%   24 MB
|=======================================================================                   |  78%   24 MB
|========================================================================                  |  79%   24 MB
|========================================================================                  |  79%   24 MB
|========================================================================                  |  80%   24 MB
|=========================================================================                 |  80%   24 MB
|=========================================================================                 |  80%   25 MB
|==========================================================================                |  81%   25 MB
|==========================================================================                |  81%   25 MB
|==========================================================================                |  82%   25 MB
|===========================================================================               |  82%   25 MB
|===========================================================================               |  83%   25 MB
|===========================================================================               |  83%   25 MB
|============================================================================              |  83%   25 MB
|============================================================================              |  84%   26 MB
|=============================================================================             |  84%   26 MB
|=============================================================================             |  85%   26 MB
|=============================================================================             |  85%   26 MB
|==============================================================================            |  85%   26 MB
|==============================================================================            |  86%   26 MB
|==============================================================================            |  86%   26 MB
|===============================================================================           |  87%   26 MB
|===============================================================================           |  87%   27 MB
|===============================================================================           |  87%   27 MB
|================================================================================          |  88%   27 MB
|================================================================================          |  88%   27 MB
|=================================================================================         |  89%   27 MB
|=================================================================================         |  89%   27 MB
|=================================================================================         |  89%   27 MB
|==================================================================================        |  90%   27 MB
|==================================================================================        |  90%   28 MB
|==================================================================================        |  91%   28 MB
|===================================================================================       |  91%   28 MB
|===================================================================================       |  91%   28 MB
|====================================================================================      |  92%   28 MB
|====================================================================================      |  92%   28 MB
|====================================================================================      |  93%   28 MB
|=====================================================================================     |  93%   28 MB
|=====================================================================================     |  94%   29 MB
|=====================================================================================     |  94%   29 MB
|======================================================================================    |  94%   29 MB
|======================================================================================    |  95%   29 MB
|=======================================================================================   |  95%   29 MB
|=======================================================================================   |  96%   29 MB
|=======================================================================================   |  96%   29 MB
|========================================================================================  |  96%   29 MB
|========================================================================================  |  97%   30 MB
|========================================================================================  |  97%   30 MB
|========================================================================================= |  98%   30 MB
|========================================================================================= |  98%   30 MB
|==========================================================================================|  98%   30 MB
|==========================================================================================|  99%   30 MB
|==========================================================================================|  99%   30 MB
|===========================================================================================| 100%   30 MB
#the 311 system
improve_detroit_issues <- read_csv("./data/Improve_Detroit_Issues_3_19_2018.csv", 
                                   guess_max = 10^6)
Parsed with column specification:
cols(
  `Ticket ID` = col_integer(),
  `Ticket Status` = col_character(),
  `Issue Type` = col_character(),
  `Issue Description` = col_character(),
  `Created At` = col_character(),
  `Acknowledged At` = col_character(),
  `Closed At` = col_character(),
  `Reopened At` = col_character(),
  `Updated At` = col_character(),
  `Days to Close` = col_double(),
  `Report Method` = col_character(),
  `Priority Code` = col_integer(),
  `Canonical Issue Id` = col_integer(),
  `Web Link` = col_character(),
  Address = col_character(),
  Neighborhood = col_character(),
  `Council District` = col_integer(),
  Location = col_character()
)

|==========                                                                                |  11%    4 MB
|===========                                                                               |  12%    4 MB
|===========                                                                               |  12%    4 MB
|============                                                                              |  13%    5 MB
|============                                                                              |  13%    5 MB
|============                                                                              |  14%    5 MB
|=============                                                                             |  14%    5 MB
|=============                                                                             |  15%    5 MB
|==============                                                                            |  15%    5 MB
|==============                                                                            |  16%    6 MB
|===============                                                                           |  16%    6 MB
|===============                                                                           |  17%    6 MB
|===============                                                                           |  17%    6 MB
|================                                                                          |  17%    6 MB
|================                                                                          |  18%    7 MB
|=================                                                                         |  18%    7 MB
|=================                                                                         |  19%    7 MB
|==================                                                                        |  19%    7 MB
|==================                                                                        |  20%    7 MB
|==================                                                                        |  20%    7 MB
|===================                                                                       |  21%    8 MB
|===================                                                                       |  21%    8 MB
|====================                                                                      |  22%    8 MB
|====================                                                                      |  22%    8 MB
|=====================                                                                     |  23%    8 MB
|=====================                                                                     |  23%    8 MB
|=====================                                                                     |  24%    9 MB
|======================                                                                    |  24%    9 MB
|======================                                                                    |  25%    9 MB
|=======================                                                                   |  25%    9 MB
|=======================                                                                   |  25%    9 MB
|========================                                                                  |  26%   10 MB
|========================                                                                  |  26%   10 MB
|========================                                                                  |  27%   10 MB
|=========================                                                                 |  27%   10 MB
|=========================                                                                 |  28%   10 MB
|==========================                                                                |  28%   10 MB
|==========================                                                                |  29%   11 MB
|===========================                                                               |  29%   11 MB
|===========================                                                               |  30%   11 MB
|===========================                                                               |  30%   11 MB
|============================                                                              |  31%   11 MB
|============================                                                              |  31%   12 MB
|=============================                                                             |  32%   12 MB
|=============================                                                             |  32%   12 MB
|==============================                                                            |  33%   12 MB
|==============================                                                            |  33%   12 MB
|==============================                                                            |  33%   12 MB
|===============================                                                           |  34%   13 MB
|===============================                                                           |  34%   13 MB
|================================                                                          |  35%   13 MB
|================================                                                          |  35%   13 MB
|=================================                                                         |  36%   13 MB
|=================================                                                         |  36%   14 MB
|=================================                                                         |  37%   14 MB
|==================================                                                        |  37%   14 MB
|==================================                                                        |  38%   14 MB
|===================================                                                       |  38%   14 MB
|===================================                                                       |  39%   14 MB
|====================================                                                      |  39%   15 MB
|====================================                                                      |  40%   15 MB
|====================================                                                      |  40%   15 MB
|=====================================                                                     |  41%   15 MB
|=====================================                                                     |  41%   15 MB
|======================================                                                    |  41%   15 MB
|======================================                                                    |  42%   16 MB
|=======================================                                                   |  42%   16 MB
|=======================================                                                   |  43%   16 MB
|=======================================                                                   |  43%   16 MB
|========================================                                                  |  44%   16 MB
|========================================                                                  |  44%   17 MB
|=========================================                                                 |  45%   17 MB
|=========================================                                                 |  45%   17 MB
|=========================================                                                 |  46%   17 MB
|==========================================                                                |  46%   17 MB
|==========================================                                                |  47%   17 MB
|===========================================                                               |  47%   18 MB
|===========================================                                               |  48%   18 MB
|============================================                                              |  48%   18 MB
|============================================                                              |  49%   18 MB
|=============================================                                             |  49%   18 MB
|=============================================                                             |  49%   19 MB
|=============================================                                             |  50%   19 MB
|==============================================                                            |  50%   19 MB
|==============================================                                            |  51%   19 MB
|===============================================                                           |  51%   19 MB
|===============================================                                           |  52%   19 MB
|================================================                                          |  52%   20 MB
|================================================                                          |  53%   20 MB
|================================================                                          |  53%   20 MB
|=================================================                                         |  54%   20 MB
|=================================================                                         |  54%   20 MB
|==================================================                                        |  55%   21 MB
|==================================================                                        |  55%   21 MB
|===================================================                                       |  56%   21 MB
|===================================================                                       |  56%   21 MB
|===================================================                                       |  57%   21 MB
|====================================================                                      |  57%   21 MB
|====================================================                                      |  58%   22 MB
|=====================================================                                     |  58%   22 MB
|=====================================================                                     |  59%   22 MB
|======================================================                                    |  59%   22 MB
|======================================================                                    |  59%   22 MB
|======================================================                                    |  60%   22 MB
|=======================================================                                   |  60%   23 MB
|=======================================================                                   |  61%   23 MB
|========================================================                                  |  61%   23 MB
|========================================================                                  |  62%   23 MB
|=========================================================                                 |  62%   23 MB
|=========================================================                                 |  63%   24 MB
|==========================================================                                |  63%   24 MB
|==========================================================                                |  64%   24 MB
|==========================================================                                |  64%   24 MB
|===========================================================                               |  65%   24 MB
|===========================================================                               |  65%   24 MB
|============================================================                              |  66%   25 MB
|============================================================                              |  66%   25 MB
|=============================================================                             |  67%   25 MB
|=============================================================                             |  67%   25 MB
|=============================================================                             |  68%   25 MB
|==============================================================                            |  68%   26 MB
|==============================================================                            |  69%   26 MB
|===============================================================                           |  69%   26 MB
|===============================================================                           |  69%   26 MB
|================================================================                          |  70%   26 MB
|================================================================                          |  70%   27 MB
|=================================================================                         |  71%   27 MB
|=================================================================                         |  71%   27 MB
|=================================================================                         |  72%   27 MB
|==================================================================                        |  72%   27 MB
|==================================================================                        |  73%   27 MB
|===================================================================                       |  73%   28 MB
|===================================================================                       |  74%   28 MB
|===================================================================                       |  74%   28 MB
|====================================================================                      |  75%   28 MB
|====================================================================                      |  75%   28 MB
|=====================================================================                     |  76%   28 MB
|=====================================================================                     |  76%   29 MB
|======================================================================                    |  76%   29 MB
|======================================================================                    |  77%   29 MB
|======================================================================                    |  77%   29 MB
|=======================================================================                   |  78%   29 MB
|=======================================================================                   |  78%   29 MB
|========================================================================                  |  79%   30 MB
|========================================================================                  |  79%   30 MB
|========================================================================                  |  80%   30 MB
|=========================================================================                 |  80%   30 MB
|=========================================================================                 |  81%   30 MB
|==========================================================================                |  81%   31 MB
|==========================================================================                |  81%   31 MB
|==========================================================================                |  82%   31 MB
|===========================================================================               |  82%   31 MB
|===========================================================================               |  83%   31 MB
|============================================================================              |  83%   31 MB
|============================================================================              |  84%   32 MB
|=============================================================================             |  84%   32 MB
|=============================================================================             |  85%   32 MB
|=============================================================================             |  85%   32 MB
|==============================================================================            |  86%   32 MB
|==============================================================================            |  86%   32 MB
|===============================================================================           |  86%   33 MB
|===============================================================================           |  87%   33 MB
|===============================================================================           |  87%   33 MB
|================================================================================          |  88%   33 MB
|================================================================================          |  88%   33 MB
|=================================================================================         |  89%   33 MB
|=================================================================================         |  89%   34 MB
|==================================================================================        |  90%   34 MB
|==================================================================================        |  90%   34 MB
|==================================================================================        |  91%   34 MB
|===================================================================================       |  91%   34 MB
|===================================================================================       |  92%   35 MB
|====================================================================================      |  92%   35 MB
|====================================================================================      |  93%   35 MB
|=====================================================================================     |  93%   35 MB
|=====================================================================================     |  93%   35 MB
|=====================================================================================     |  94%   35 MB
|======================================================================================    |  94%   36 MB
|======================================================================================    |  95%   36 MB
|=======================================================================================   |  95%   36 MB
|=======================================================================================   |  96%   36 MB
|========================================================================================  |  96%   36 MB
|========================================================================================  |  97%   37 MB
|========================================================================================  |  97%   37 MB
|========================================================================================= |  98%   37 MB
|========================================================================================= |  98%   37 MB
|==========================================================================================|  99%   37 MB
|==========================================================================================|  99%   37 MB
|===========================================================================================| 100%   38 MB
#the shapefile representing Detroit parcels, read into 
parcel_sf <- st_read("./data/Parcel Map")
Reading layer `geo_export_ad366f11-96e5-4f0f-9d17-7a6ae8e48482' from data source `/Users/stuartbarnum/Desktop/R files/Detroit-Demolitions/data/Parcel Map' using driver `ESRI Shapefile'
Simple feature collection with 382051 features and 37 fields
geometry type:  MULTIPOLYGON
dimension:      XY
bbox:           xmin: -83.28763 ymin: 42.25539 xmax: -82.91066 ymax: 42.45011
epsg (SRID):    4326
proj4string:    +proj=longlat +ellps=WGS84 +no_defs
#writeLines(c("parcel_sf", " ", colnames(parcel_sf)), "parcel_sf.txt")

For all of the downloaded datasets other than the parcels dataset, we extract extract the usable latutude and longitude values and then use this information to form simple features (sf) objects. Rows with bviously incorrect values, or values that would represent positions well outside Detroit, are filtered out, together with rows for which the latitude or longitude data is missing.

#function for converting the position (character) column into a column of points in the simple features (sf) framework.
add_sf_point <- function(df, column) {
  
  #extract the latitude and longitude from the string column that contains both. With the parentheses
  #located from the end of the strings, it is possible to use the the same function for all five of 
  #the datasets for which we need to extract this information.
  latitude <- str_sub(df[[column]], 
                      stringi::stri_locate_last_fixed(df[[column]], "(")[,2] + 1,
                      stringi::stri_locate_last_fixed(df[[column]], ",")[,1] - 1)
  longitude <- str_sub(df[[column]], 
                       stringi::stri_locate_last_fixed(df[[column]], ", ")[,2] + 1, 
                       stringi::stri_locate_last_fixed(df[[column]], ")")[,1] - 1)
  
  #add the latititude and and longitude to a copy of the dataframe, filter out the NAs from
  #these results, and then convert convert to sf, with point positions indicated in the
  #geometry column
  mutated <- df %>% mutate(extracted_lat = as.double(latitude),
                      extracted_lon = as.double(longitude))
  
  #remove rows with NAs for latitude or longitude, or with values well outside of Detroit
  filtered <- mutated %>%
    filter(!is.na(extracted_lat) & !is.na(extracted_lon)) %>%
    filter(41 < extracted_lat & extracted_lat < 44 & -85 < extracted_lon & extracted_lon < -81)
    
  #create a dataframe from the items that have been filtered out
  result_coord_na <- setdiff(mutated, filtered)
  
  #create sf objects from the rows with usable latitude and longitude information
  result_sf <- st_as_sf(filtered, coords = c("extracted_lon", "extracted_lat"), crs = 4326)
    
  return(list(result_sf, result_coord_na))
}
#apply the function to the five datasets for which the data was not loaded as a simple features dataframe, thus producing a list of two dataframes for each of the datasets, the first element of the list a simple features data frame and the second element a dataframe with the instances for which it was not possible to convert to simple features
blight_violations_split <- add_sf_point(blight_violations, "Violation Location")
dismantle_permits_split <- add_sf_point(dismantle_permits, "Permit Location")
crime_to_12062016_split <- add_sf_point(crime_to_12062016, "LOCATION")
crime_12062016_to_03192018_split <- add_sf_point(crime_12062016_to_03192018, "Location")
improve_detroit_issues_split <- add_sf_point(improve_detroit_issues, "Location")

We now consider the data for which we do not yet have position data, and complete the information as well as we reasonably can, using the Google api and a function, geocode_pause, that handles some of api’s quirks.

#the portino of the downloaded blight citations data, for which we do not have
blight_vio_na <- blight_violations_split[[2]]
#remove the rows for which geocoding is not likely to prodoce reliable results
useful <- blight_vio_na %>% filter(!is.na(`Violation Street Name`), 
                                   `Violation Street Number` > 0, 
                                   !is.na(`Violation Zip Code`))
#create a column of addresses to be used in geocoding
useful <- useful %>% 
  mutate(complete_address = paste(`Violation Street Number`, " ", `Violation Street Name`, ", ",
                                  "Detroit, Michigan", " ", `Violation Zip Code`, sep = ""))
#function makes a maximum 6 attempts to geocode the given address using the Google API, with a pause of 1 second between attempts. We will use the function for the other datasets as well.
geocode_pause <- function(address) {
  for (index in 1:6) {
    Sys.sleep(1)
    location <- ggmap::geocode(address)
    if (!is.na(location$lon)) {
      return(location)
    }
  }
}
#apply geocode_pause to each of the elements of the complete_addresse column and place the result in a new column, in which each entry is a data frame 
useful <- useful %>% mutate(location = map(complete_address, geocode_pause))

#save to disc, to avoid avoid the need to geocode these addresses again when we rerun the analysis
write_rds(useful, "./data/blight_violations_geocodes.rds")

The geocoding has returned a data frame for each of the addresses. We thus need to unpack the elements of the location column, each of which is a data frame.

#read blight_violations_geocodes as a tibble
blight_violations_geocodes <- read_rds("./data/blight_violations_geocodes.rds")
#function for removing the instances for which geocoding failed (for which the value in the location column is NULLL). We will use this function for all of the geocoded data frames.
remove_null_locations <- function(df) {
  #identify the rows for which the value in the location column is NULL
  null_rows <- list()
  for (index in 1:nrow(df)) {
    if (is.null(df$location[[index]])) {
      null_rows <- c(null_rows, index)
    }
  }
  #remove the rows for which the value of the location column is NULL
  df <- df[-as.integer(null_rows),]
}
blight_violations_geocodes <- remove_null_locations(blight_violations_geocodes)
#With blight_violations_geocodes a tibble, we can apply tidyr::unnest(), which will place the latitude and longitude in columns labelled "lat" and "lon".
blight_violations_geocodes <- blight_violations_geocodes %>% unnest(location)
#fill in the `Violation Latitute` and `Violation Longitude` data frames, which alread exist in the blight_violations data frame
blight_violations_geocodes <- blight_violations_geocodes %>%
  mutate(`Violation Latitude` = lat,
         `Violation Longitude` = lon)
#cut out some columns that have been added
blight_violations_geocodes <- blight_violations_geocodes %>% 
  select(-extracted_lat, -extracted_lon, -complete_address)
#put the position information into a simple features format (which will remove the "lat" and "lon" columns)
blight_violations_geocodes_sf <- st_as_sf(blight_violations_geocodes, 
                                          coords = c("lon", "lat"),
                                          crs = 4326)
#combine the results with the previously generated sf data
blight_violations_sf <- rbind(blight_violations_split[[1]], blight_violations_geocodes_sf)
rm(blight_vio_na, blight_violations, blight_violations_geocodes, 
   blight_violations_geocodes_sf, blight_violations_split, useful)
#the dismantle permits for which position data (latitude and longitude) is missing
dismantle_permits_split_na <- dismantle_permits_split[[2]]
#remove the last two columns, which were not contained in the original dismantle_permits datastet
dismantle_permits_split_na <- dismantle_permits_split_na %>% 
  select(-extracted_lat, -extracted_lon)
#geocode the items in dismantle_permits_split_na, using the address column and the function geocode_pause, which makes a maximum of six attempts for each item. The result is list of dataframes in the location column.
dismantle_permits_split_geocode <- dismantle_permits_split_na %>%
  mutate(location = map(str_c(`Site Address`, ", Detroit, Michigan"), geocode_pause))

#write the results of the geocoding to disk, to avoid having to repeat the geocoding when rerunning the analysis.
write_rds(dismantle_permits_split_geocode, "./data/dismantle_permits_geocodes.rds")

rm(dismantle_permits_split_na)
#load the geocoded data frame into R
dismantle_permits_split_geocode <- read_rds("./data/dismantle_permits_geocodes.rds")
#use the remove_null_locations() to remove the rows for which geocoding failed and then parse the information  in the dataframes in the location column into two new columns, lat and lan
dismantle_permits_split_geocode <- 
  remove_null_locations(dismantle_permits_split_geocode) %>%
  unnest(location)
#convert to a simple features (sf) data frame, using the latititudes and longitudes
dismantle_permits_geocode_sf <- st_as_sf(dismantle_permits_split_geocode, 
                                          coords = c("lon", "lat"),
                                          crs = 4326)
#append this simple features dataframe to the dataframe for which we already had usable positions
dismantle_permits_sf <- rbind(dismantle_permits_split[[1]], dismantle_permits_geocode_sf)
rm(dismantle_permits_split_geocode, dismantle_permits_geocode_sf, dismantle_permits, dismantle_permits_split, dismantle_permits_split_na)

We now fill-in the missing position information for the dataset for crimes up to 12-06-2016

#return to the older crime data
crime_to_12062016_leftovers <- crime_to_12062016_split[[2]]
#cut out the addresses that begin with "00"
crime_to_12062016_leftovers <- crime_to_12062016_leftovers %>% 
  filter(str_sub(LOCATION, 1, 2) != "00")
#filter out some obviously useless addresses, with few characters before the first "("
crime_to_12062016_leftovers <- crime_to_12062016_leftovers %>% 
  filter(!str_locate(LOCATION, "\\(")[,1] %in% 1:13)
#remove the two columns that were added earlier
crime_to_12062016_leftovers <- crime_to_12062016_leftovers %>% 
  select(-extracted_lat, -extracted_lon)
#create a column for use in geocoding
crime_to_12062016_leftovers <- crime_to_12062016_leftovers %>% 
  mutate(extracted_address = str_c(str_sub(LOCATION, 1, 
                                           str_locate(LOCATION, "\\(")[,1] - 2),
                                                      ", Detroit, Michigan"))
#geocode the elements of extracted_address, using the function geocode_pause
crime_to_12062016_leftovers_geocode <- crime_to_12062016_leftovers %>% 
  mutate(location = map(extracted_address, geocode_pause))

#save the results, to avoid having to geocode again when rerunning the analysis
write_rds(crime_to_12062016_leftovers_geocode, "./data/crime_to_12062016_leftovers_geocode.rds")
crime_to_12062016_leftovers_geocode <- read_rds("./data/crime_to_12062016_leftovers_geocode.rds")
#cut out the column we used for geocoding
crime_to_12062016_leftovers_geocode <- 
  crime_to_12062016_leftovers_geocode %>% select(-extracted_address)
  
#cut out of the geocode failures and put the location information into the columns lat and lon
crime_to_12062016_leftovers_geocode <- 
  remove_null_locations(crime_to_12062016_leftovers_geocode) %>%
  unnest(location)
#create a simple features (sf) object, using the latititudes and longitudes
crime_to_12062016_leftovers_sf <- st_as_sf(crime_to_12062016_leftovers_geocode, 
                                          coords = c("lon", "lat"),
                                          crs = 4326)
#append this simple features dataframe to the dataframe for which we already had locations
crime_to_12062016_sf <- rbind(crime_to_12062016_split[[1]], crime_to_12062016_leftovers_sf)
rm(crime_to_12062016, crime_to_12062016_leftovers_geocode, crime_to_12062016_leftovers_sf, crime_to_12062016_leftovers, crime_to_12062016_split)
#consider the examples in the recent crime data for which the conversion to sf didn't work, remove the two columns that we have added, and create and address column for geocoding
crime_12062016_to_03192018_leftovers <- crime_12062016_to_03192018_split[[2]] %>%
  select(-extracted_lat, -extracted_lon) %>%
  mutate(extracted_address = str_c(`Incident Address`, ", Detroit, Michigan"))
crime_12062016_to_03192018_geocode <- crime_12062016_to_03192018_leftovers %>% 
  mutate(location = map(extracted_address, geocode_pause))

write_rds(crime_12062016_to_03192018_geocode, "./data/crime_12062016_to_03192018_geocode.rds")
crime_12062016_to_03192018_geocode <- read_rds("./data/crime_12062016_to_03192018_geocode.rds") %>%
  select(-extracted_address)
#remove the rows for which the value of location is NULL and then unnest the remaining locations
crime_12062016_to_03192018_geocode <- 
  remove_null_locations(crime_12062016_to_03192018_geocode) %>%
  unnest(location)
#convert the dataframe to a simple features set
crime_12062016_to_03192018_sf <- st_as_sf(crime_12062016_to_03192018_geocode, 
                                          coords = c("lon", "lat"),
                                          crs = 4326)  
#combine the geocoded data with the sf dataframe created earlier
crime_12062016_to_03192018 <- rbind(crime_12062016_to_03192018_split[[1]], crime_12062016_to_03192018_sf)
rm(crime_12062016_to_03192018_split, crime_12062016_to_03192018_geocode, crime_12062016_to_03192018_leftovers, crime_12062016_to_03192018_sf)
#geocode the one item in the Improve Detroit Issues data for which the given coordinates were obviously incorrect, and then convert to an sf object. If geocoding fails, run this bit again
improve_detroit_issues_leftover_sf <- improve_detroit_issues_split[[2]] %>%
  select(-extracted_lat, -extracted_lon) %>%
  mutate(location = map(Address, geocode_pause)) %>%
  unnest(location) %>% 
  st_as_sf(coords = c("lon", "lat"), crs = 4326)  
Error in eval(lhs, parent, parent) : 
  object 'improve_detroit_issues_split' not found

We begin the assignment of labels to the buidings: blighted or not blighted. Buildings will be represented by parcels that have or have had buildings on them, whether by being so represented as in the parcels_sf data frame as including structures or in the dismantle permits dataframe as having had a dismante permit associated with it, thus suggesting that there was a building on the parcel.

We will use parcel numbers to refer to the parcels. This works because parcelnum column contains no repeats over different rows (see below, in which duplicate_parcel_numbers_in_parcel_data has zero rows).

#As per above, following returns an empty data frame
duplicate_parcel_numbers_in_parcel_data <- 
  parcel_sf %>%
  group_by(parcelnum) %>% 
  mutate(n = n()) %>%
  ungroup() %>% 
  filter(n > 1)
duplicate_parcel_numbers_in_parcel_data
Simple feature collection with 78 features and 38 fields
geometry type:  MULTIPOLYGON
dimension:      XY
bbox:           xmin: -83.17034 ymin: 42.32219 xmax: -83.0055 ymax: 42.4416
epsg (SRID):    4326
proj4string:    +proj=longlat +ellps=WGS84 +no_defs
rm(duplicate_parcel_numbers_in_parcel_data)

The dismantle permits data, however, may seem less clean than the parcel_sf, as it contains repetitions of the parcel numbers that correspond to different addresses that would refer, in some cases, to distinct locations. (It also indicates that a few individual locatations, identified with addresses, had more than one associated dismantle permit. This need not be problematic—a permit could expire before the work is carried out, or there could be more than one structure on a parcel.) These repetitions are in duplicate_parcel_numbers_over_distinct_addresses, which contains 260 rows. I should also note that, in most of these cases with duplicate parcel numbers (and addresses indicating different locations), the recorded latitude and longitude are identical. We can thus infer that some of this location information is incorrect.

dup_par_num_in_dismantle_data <-
  dismantle_permits_sf %>%
  group_by(`Parcel Number`) %>% 
  mutate(n = n()) %>%
  ungroup() %>% 
  filter(n > 1) %>%
  select(`Parcel Number`, `Site Address`)
as.data.frame(dup_par_num_in_dismantle_data)
rm(dup_par_num_in_dismantle_data)
#parcel numbers in the dismantle permits data that are distributed over disinct addresseses
dup_par_num_over_distinct_addresses <- 
  dismantle_permits_sf %>%
  group_by(`Parcel Number`) %>%
  mutate(parcel_number_occurances = n()) %>%
  ungroup() %>%
  filter(parcel_number_occurances > 1) %>%
  select(`Parcel Number`, `Site Address`, parcel_number_occurances) %>%
  group_by(`Parcel Number`, `Site Address`) %>%
  mutate(m = n()) %>%
  filter(m < parcel_number_occurances) %>%
  arrange(`Parcel Number`)
as.data.frame(dup_par_num_over_distinct_addresses)
rm(dup_par_num_over_distinct_addresses)

Some of repeats of the parcel numbers would seem to correspond to the some location (with the addresses recorded somewhat differently), while others would not. The numbers rows in question is relatively small (272), so I will ignore the issue for now. (I will eventually either remove this data are attempt to attache the correct location information.)

#note that the following removes rows with duplicate parcels
#duplicate_parcel_numbers %>% distinct(parcelnum, .keep_all = TRUE)

parcel_join_sf_parcel_first <- 
  full_join(parcel_sf %>% select(parcelnum),
            dismantle_permits_sf %>% as.data.frame() %>% select(`Parcel Number`),
            c("parcelnum" = "Parcel Number")) %>%
  arrange(`Parcel Number`)

parcel_join_sf_dismantle_first <-
  full_join(dismantle_permits_sf %>% select(`Parcel Number`), 
            parcel_sf %>% as.data.frame() %>% select(parcelnum),
            c("Parcel Number" = "parcelnum")) %>%
  arrange(`Parcel Number`)

st_crs(parcel_sf)
st_crs(dismantle_permits_sf)

#Both of these yield an EPSG of 4326. Nethereless, the follow step seems necessary.

st_crs(dismantle_permits_sf) <- st_crs(parcel_sf)

temp <- st_join(dismantle_permits_sf, parcel_sf, join = st_within)
  
temp2 <- temp %>% filter(`Parcel Number` != parcelnum)

temp2 <- temp2 %>% select(`Parcel Number`, parcelnum, `Site Address`, address)


#note that objectid in parcel_sf has no NA values, and that objectid is a key in parcel_sf
parcel_sf %>% as.data.frame() %>% filter(is.na(objectid))
parcel_sf %>% count(objectid) %>% filter(n > 1)

#note that `Permit Number` is a also a key, for dismantle_permits_sf
dismantle_permits_sf %>% as.data.frame() %>% filter(is.na(`Permit Number`))
dismantle_permits_sf %>% count(`Permit Number`) %>% filter(n > 1)

#with the above in mind, we examine the NA values for these columns in our full join, beginning with objectid in parcel_sf. The idea is that any NA value for objectid in parcel_join would correspond to a parcel in the dismantle permits dataset that is either not reflected in the parcels dataset or for which there is a flaw in the data.
parcel_join %>% filter(is.na(objectid))

dismantle_permits_sf %>% filter(`Parcel Number` == "22108512.")

#dismantled_structures <- initial_join %>% filter(!is.na(`Permit Number`))

parcel_sf %>% filter(parcelnum == "22108512.")

parcel_tmp <- blight_violations_sf[c(1, 2),]

st_distance(parcel_tmp)

m_list <- mapply(st_distance, blight_violations_sf$geometry[1], fred$geometry)

dismantle_permits_sf %>% as.data.frame() %>% filter(is.na(`Parcel Number`))

temp4 <- st_distance(parcel_sf[195099,], 
            blight_violations_sf[22233:22255,])

st_crs(blight_violations_sf) <- st_crs(parcel_sf)

plot(blight_violations_sf, max.plot = 1)

Maps:

library(ggmap)

ggplot(blight_violations_sf %>% select(geometry)) +
  geom_sf() + 
  geom_density2d(data = blight_violations_sf %>% select(geometry))


ggplot(data=xy.sf) +
    geom_sf() +
    geom_density2d(data=xy.sf, aes(x=x,y=y,colour=..level..))


detroit_gg <- get_map("Detroit", maptype = "toner-lite",
                      zoom = 11)

ggmap(detroit_gg)
LS0tCnRpdGxlOiAiQmxpZ2h0IFByZWRpY3Rpb25zIGZvciBEZXRyb2l0IgpvdXRwdXQ6IGh0bWxfbm90ZWJvb2sKLS0tCgpJbiB0aGlzIHByb2plY3QsIEkgd2lsbCBhdHRlbXB0IHRvIHByZWRpY3Qgd2hldGhlciwgZm9yIGFueSBnaXZlbiBwYXJjZWwgaW4gRGV0cm9pdCB3aXRoIGEgYnVpbGRpbmcgb24gaXQsIHdoZXRoZXIgYSBidWlsZGluZyBvbiB0aGF0IHBhcmNlbCB3aWxsIGJlIGJlIHRhcmdldHRlZCBmb3IgZGVtb2x0aW9uLiBQb3RlbnRpYWwgcHJlZGljdG9ycywgZG93bmxvYWRlZCBmcm9tICBodHRwczovL2RhdGEuZGV0cm9pdG1pLmdvdi8sIGluY2x1ZGUgY2l0YXRpb25zIHJlbGF0YXRlZCB0byB0aGUgYnVpbGRpbmcsIGNyaW1lLCBhbmQgY29tcGxhaW50cyBjb25jZXJuaW5nIHRoZSBidWlsZGluZyByZWxhdGVkIHRvIGJsaWdodC4gVGhlIHByb2JqZWN0IGlzIGN1cnJlbnRseSBhdCB0aGUgZGF0YSBjbGVhbmluZyBzdGFnZSwgYW5kIEkgbWF5IGFkZCBzb21lIG90aGVyIGRhdGEgdG8gdGhlIHByb2plY3QuIFNvIGZhciwgSSBhbSB1c2luZyBhYm91dCAzR0Igb2YgZGF0YS4KCgpgYGB7cn0KbGlicmFyeSh0aWR5dmVyc2UpCmxpYnJhcnkoc2YpCmxpYnJhcnkoZ2dtYXApCmxpYnJhcnkobHdnZW9tKQoKI3JlY29yZGVkIHZpb2xhdGlvbnMgYXNzb2NpYXRlZCB3aXRoIGJsaWdodCAoZS5nLiB1bmtlbXB0IHByb3BlcnRpZXMpCmJsaWdodF92aW9sYXRpb25zIDwtIHJlYWRfY3N2KCIuL2RhdGEvQmxpZ2h0X1Zpb2xhdGlvbnNfM18xOV8yMDE4LmNzdiIsIAogICAgICAgICAgICAgICAgICAgICAgICAgICAgICBndWVzc19tYXggPSAxMF42KQoKI3JlYWQgdGhlIGRvd25sb2FkZWQgZmlsZSBmb3IgYWxsIHRoZSBidWlsZGluZyBwZXJtaXRzIGFuZCB0aGVuIGZpbHRlciBvdXQgdGhlIHBlcm1pdHMgZm9yIGRpc21hbnRsaW5nCmRpc21hbnRsZV9wZXJtaXRzIDwtIHJlYWRfY3N2KCIuL2RhdGEvQnVpbGRpbmdfUGVybWl0c18zXzE5XzIwMTguY3N2IiwgCiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgZ3Vlc3NfbWF4ID0gMTBeNikgJT4lCiAgZmlsdGVyKGBCdWlsZGluZyBQZXJtaXQgVHlwZWAgPT0gIkRpc21hbnRsZSIpCiAgCiN0aGUgZmlsZXMgdGhhdCBjb250YWluIHRoZSBjcmltZSBkYXRhCmNyaW1lX3RvXzEyMDYyMDE2IDwtIAogIHJlYWRfY3N2KCIuL2RhdGEvRFBEX19BbGxfQ3JpbWVfSW5jaWRlbnRzX19KYW51YXJ5XzFfXzIwMDlfLV9EZWNlbWJlcl82X18yMDE2LmNzdiIsCiAgICAgICAgICAgZ3Vlc3NfbWF4ID0gMTBeNikKCmNyaW1lXzEyMDYyMDE2X3RvXzAzMTkyMDE4IDwtIAogIHJlYWRfY3N2KCIuL2RhdGEvRFBEX19BbGxfQ3JpbWVfSW5jaWRlbnRzX19EZWNlbWJlcl82X18yMDE2Xy1fM18xOV8yMDE4LmNzdiIsIAogICAgICAgICAgIGd1ZXNzX21heCA9IDEwXjYpCgojdGhlIDMxMSBzeXN0ZW0KaW1wcm92ZV9kZXRyb2l0X2lzc3VlcyA8LSByZWFkX2NzdigiLi9kYXRhL0ltcHJvdmVfRGV0cm9pdF9Jc3N1ZXNfM18xOV8yMDE4LmNzdiIsIAogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIGd1ZXNzX21heCA9IDEwXjYpCgojdGhlIHNoYXBlZmlsZSByZXByZXNlbnRpbmcgRGV0cm9pdCBwYXJjZWxzLCByZWFkIGludG8gCnBhcmNlbF9zZiA8LSBzdF9yZWFkKCIuL2RhdGEvUGFyY2VsIE1hcCIpCgojd3JpdGVMaW5lcyhjKCJwYXJjZWxfc2YiLCAiICIsIGNvbG5hbWVzKHBhcmNlbF9zZikpLCAicGFyY2VsX3NmLnR4dCIpCgpgYGAKCkZvciBhbGwgb2YgdGhlIGRvd25sb2FkZWQgZGF0YXNldHMgb3RoZXIgdGhhbiB0aGUgcGFyY2VscyBkYXRhc2V0LCB3ZSBleHRyYWN0IGV4dHJhY3QgdGhlIHVzYWJsZSBsYXR1dHVkZSBhbmQgbG9uZ2l0dWRlIHZhbHVlcyBhbmQgdGhlbiB1c2UgdGhpcyBpbmZvcm1hdGlvbiB0byBmb3JtIHNpbXBsZSBmZWF0dXJlcyAoc2YpIG9iamVjdHMuIFJvd3Mgd2l0aCBidmlvdXNseSBpbmNvcnJlY3QgdmFsdWVzLCBvciB2YWx1ZXMgdGhhdCB3b3VsZCByZXByZXNlbnQgcG9zaXRpb25zIHdlbGwgb3V0c2lkZSBEZXRyb2l0LCBhcmUgZmlsdGVyZWQgb3V0LCB0b2dldGhlciB3aXRoIHJvd3MgZm9yIHdoaWNoIHRoZSBsYXRpdHVkZSBvciBsb25naXR1ZGUgZGF0YSBpcyBtaXNzaW5nLgoKYGBge3J9CgojZnVuY3Rpb24gZm9yIGNvbnZlcnRpbmcgdGhlIHBvc2l0aW9uIChjaGFyYWN0ZXIpIGNvbHVtbiBpbnRvIGEgY29sdW1uIG9mIHBvaW50cyBpbiB0aGUgc2ltcGxlIGZlYXR1cmVzIChzZikgZnJhbWV3b3JrLgphZGRfc2ZfcG9pbnQgPC0gZnVuY3Rpb24oZGYsIGNvbHVtbikgewogIAogICNleHRyYWN0IHRoZSBsYXRpdHVkZSBhbmQgbG9uZ2l0dWRlIGZyb20gdGhlIHN0cmluZyBjb2x1bW4gdGhhdCBjb250YWlucyBib3RoLiBXaXRoIHRoZSBwYXJlbnRoZXNlcwogICNsb2NhdGVkIGZyb20gdGhlIGVuZCBvZiB0aGUgc3RyaW5ncywgaXQgaXMgcG9zc2libGUgdG8gdXNlIHRoZSB0aGUgc2FtZSBmdW5jdGlvbiBmb3IgYWxsIGZpdmUgb2YgCiAgI3RoZSBkYXRhc2V0cyBmb3Igd2hpY2ggd2UgbmVlZCB0byBleHRyYWN0IHRoaXMgaW5mb3JtYXRpb24uCiAgbGF0aXR1ZGUgPC0gc3RyX3N1YihkZltbY29sdW1uXV0sIAogICAgICAgICAgICAgICAgICAgICAgc3RyaW5naTo6c3RyaV9sb2NhdGVfbGFzdF9maXhlZChkZltbY29sdW1uXV0sICIoIilbLDJdICsgMSwKICAgICAgICAgICAgICAgICAgICAgIHN0cmluZ2k6OnN0cmlfbG9jYXRlX2xhc3RfZml4ZWQoZGZbW2NvbHVtbl1dLCAiLCIpWywxXSAtIDEpCiAgbG9uZ2l0dWRlIDwtIHN0cl9zdWIoZGZbW2NvbHVtbl1dLCAKICAgICAgICAgICAgICAgICAgICAgICBzdHJpbmdpOjpzdHJpX2xvY2F0ZV9sYXN0X2ZpeGVkKGRmW1tjb2x1bW5dXSwgIiwgIilbLDJdICsgMSwgCiAgICAgICAgICAgICAgICAgICAgICAgc3RyaW5naTo6c3RyaV9sb2NhdGVfbGFzdF9maXhlZChkZltbY29sdW1uXV0sICIpIilbLDFdIC0gMSkKICAKICAjYWRkIHRoZSBsYXRpdGl0dWRlIGFuZCBhbmQgbG9uZ2l0dWRlIHRvIGEgY29weSBvZiB0aGUgZGF0YWZyYW1lLCBmaWx0ZXIgb3V0IHRoZSBOQXMgZnJvbQogICN0aGVzZSByZXN1bHRzLCBhbmQgdGhlbiBjb252ZXJ0IGNvbnZlcnQgdG8gc2YsIHdpdGggcG9pbnQgcG9zaXRpb25zIGluZGljYXRlZCBpbiB0aGUKICAjZ2VvbWV0cnkgY29sdW1uCiAgbXV0YXRlZCA8LSBkZiAlPiUgbXV0YXRlKGV4dHJhY3RlZF9sYXQgPSBhcy5kb3VibGUobGF0aXR1ZGUpLAogICAgICAgICAgICAgICAgICAgICAgZXh0cmFjdGVkX2xvbiA9IGFzLmRvdWJsZShsb25naXR1ZGUpKQogIAogICNyZW1vdmUgcm93cyB3aXRoIE5BcyBmb3IgbGF0aXR1ZGUgb3IgbG9uZ2l0dWRlLCBvciB3aXRoIHZhbHVlcyB3ZWxsIG91dHNpZGUgb2YgRGV0cm9pdAogIGZpbHRlcmVkIDwtIG11dGF0ZWQgJT4lCiAgICBmaWx0ZXIoIWlzLm5hKGV4dHJhY3RlZF9sYXQpICYgIWlzLm5hKGV4dHJhY3RlZF9sb24pKSAlPiUKICAgIGZpbHRlcig0MSA8IGV4dHJhY3RlZF9sYXQgJiBleHRyYWN0ZWRfbGF0IDwgNDQgJiAtODUgPCBleHRyYWN0ZWRfbG9uICYgZXh0cmFjdGVkX2xvbiA8IC04MSkKICAgIAogICNjcmVhdGUgYSBkYXRhZnJhbWUgZnJvbSB0aGUgaXRlbXMgdGhhdCBoYXZlIGJlZW4gZmlsdGVyZWQgb3V0CiAgcmVzdWx0X2Nvb3JkX25hIDwtIHNldGRpZmYobXV0YXRlZCwgZmlsdGVyZWQpCiAgCiAgI2NyZWF0ZSBzZiBvYmplY3RzIGZyb20gdGhlIHJvd3Mgd2l0aCB1c2FibGUgbGF0aXR1ZGUgYW5kIGxvbmdpdHVkZSBpbmZvcm1hdGlvbgogIHJlc3VsdF9zZiA8LSBzdF9hc19zZihmaWx0ZXJlZCwgY29vcmRzID0gYygiZXh0cmFjdGVkX2xvbiIsICJleHRyYWN0ZWRfbGF0IiksIGNycyA9IDQzMjYpCiAgICAKICByZXR1cm4obGlzdChyZXN1bHRfc2YsIHJlc3VsdF9jb29yZF9uYSkpCn0KCiNhcHBseSB0aGUgZnVuY3Rpb24gdG8gdGhlIGZpdmUgZGF0YXNldHMgZm9yIHdoaWNoIHRoZSBkYXRhIHdhcyBub3QgbG9hZGVkIGFzIGEgc2ltcGxlIGZlYXR1cmVzIGRhdGFmcmFtZSwgdGh1cyBwcm9kdWNpbmcgYSBsaXN0IG9mIHR3byBkYXRhZnJhbWVzIGZvciBlYWNoIG9mIHRoZSBkYXRhc2V0cywgdGhlIGZpcnN0IGVsZW1lbnQgb2YgdGhlIGxpc3QgYSBzaW1wbGUgZmVhdHVyZXMgZGF0YSBmcmFtZSBhbmQgdGhlIHNlY29uZCBlbGVtZW50IGEgZGF0YWZyYW1lIHdpdGggdGhlIGluc3RhbmNlcyBmb3Igd2hpY2ggaXQgd2FzIG5vdCBwb3NzaWJsZSB0byBjb252ZXJ0IHRvIHNpbXBsZSBmZWF0dXJlcwpibGlnaHRfdmlvbGF0aW9uc19zcGxpdCA8LSBhZGRfc2ZfcG9pbnQoYmxpZ2h0X3Zpb2xhdGlvbnMsICJWaW9sYXRpb24gTG9jYXRpb24iKQoKZGlzbWFudGxlX3Blcm1pdHNfc3BsaXQgPC0gYWRkX3NmX3BvaW50KGRpc21hbnRsZV9wZXJtaXRzLCAiUGVybWl0IExvY2F0aW9uIikKCmNyaW1lX3RvXzEyMDYyMDE2X3NwbGl0IDwtIGFkZF9zZl9wb2ludChjcmltZV90b18xMjA2MjAxNiwgIkxPQ0FUSU9OIikKCmNyaW1lXzEyMDYyMDE2X3RvXzAzMTkyMDE4X3NwbGl0IDwtIGFkZF9zZl9wb2ludChjcmltZV8xMjA2MjAxNl90b18wMzE5MjAxOCwgIkxvY2F0aW9uIikKCmltcHJvdmVfZGV0cm9pdF9pc3N1ZXNfc3BsaXQgPC0gYWRkX3NmX3BvaW50KGltcHJvdmVfZGV0cm9pdF9pc3N1ZXMsICJMb2NhdGlvbiIpCgpgYGAKCldlIG5vdyBjb25zaWRlciB0aGUgZGF0YSBmb3Igd2hpY2ggd2UgZG8gbm90IHlldCBoYXZlIHBvc2l0aW9uIGRhdGEsIGFuZCBjb21wbGV0ZSB0aGUgaW5mb3JtYXRpb24gYXMgd2VsbCBhcyB3ZSByZWFzb25hYmx5IGNhbiwgdXNpbmcgdGhlIEdvb2dsZSBhcGkgYW5kIGEgZnVuY3Rpb24sIGBnZW9jb2RlX3BhdXNlYCwgdGhhdCBoYW5kbGVzIHNvbWUgb2YgYXBpJ3MgcXVpcmtzLgoKYGBge3J9CgojdGhlIHBvcnRpbm8gb2YgdGhlIGRvd25sb2FkZWQgYmxpZ2h0IGNpdGF0aW9ucyBkYXRhLCBmb3Igd2hpY2ggd2UgZG8gbm90IGhhdmUKYmxpZ2h0X3Zpb19uYSA8LSBibGlnaHRfdmlvbGF0aW9uc19zcGxpdFtbMl1dCgojcmVtb3ZlIHRoZSByb3dzIGZvciB3aGljaCBnZW9jb2RpbmcgaXMgbm90IGxpa2VseSB0byBwcm9kb2NlIHJlbGlhYmxlIHJlc3VsdHMKdXNlZnVsIDwtIGJsaWdodF92aW9fbmEgJT4lIGZpbHRlcighaXMubmEoYFZpb2xhdGlvbiBTdHJlZXQgTmFtZWApLCAKICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICBgVmlvbGF0aW9uIFN0cmVldCBOdW1iZXJgID4gMCwgCiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIWlzLm5hKGBWaW9sYXRpb24gWmlwIENvZGVgKSkKCiNjcmVhdGUgYSBjb2x1bW4gb2YgYWRkcmVzc2VzIHRvIGJlIHVzZWQgaW4gZ2VvY29kaW5nCnVzZWZ1bCA8LSB1c2VmdWwgJT4lIAogIG11dGF0ZShjb21wbGV0ZV9hZGRyZXNzID0gcGFzdGUoYFZpb2xhdGlvbiBTdHJlZXQgTnVtYmVyYCwgIiAiLCBgVmlvbGF0aW9uIFN0cmVldCBOYW1lYCwgIiwgIiwKICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICJEZXRyb2l0LCBNaWNoaWdhbiIsICIgIiwgYFZpb2xhdGlvbiBaaXAgQ29kZWAsIHNlcCA9ICIiKSkKCiNmdW5jdGlvbiBtYWtlcyBhIG1heGltdW0gNiBhdHRlbXB0cyB0byBnZW9jb2RlIHRoZSBnaXZlbiBhZGRyZXNzIHVzaW5nIHRoZSBHb29nbGUgQVBJLCB3aXRoIGEgcGF1c2Ugb2YgMSBzZWNvbmQgYmV0d2VlbiBhdHRlbXB0cy4gV2Ugd2lsbCB1c2UgdGhlIGZ1bmN0aW9uIGZvciB0aGUgb3RoZXIgZGF0YXNldHMgYXMgd2VsbC4KZ2VvY29kZV9wYXVzZSA8LSBmdW5jdGlvbihhZGRyZXNzKSB7CiAgZm9yIChpbmRleCBpbiAxOjYpIHsKICAgIFN5cy5zbGVlcCgxKQogICAgbG9jYXRpb24gPC0gZ2dtYXA6Omdlb2NvZGUoYWRkcmVzcykKICAgIGlmICghaXMubmEobG9jYXRpb24kbG9uKSkgewogICAgICByZXR1cm4obG9jYXRpb24pCiAgICB9CiAgfQp9CmBgYAoKCmBgYHtyLCBldmFsID0gRkFMU0V9CiNhcHBseSBnZW9jb2RlX3BhdXNlIHRvIGVhY2ggb2YgdGhlIGVsZW1lbnRzIG9mIHRoZSBjb21wbGV0ZV9hZGRyZXNzZSBjb2x1bW4gYW5kIHBsYWNlIHRoZSByZXN1bHQgaW4gYSBuZXcgY29sdW1uLCBpbiB3aGljaCBlYWNoIGVudHJ5IGlzIGEgZGF0YSBmcmFtZSAKdXNlZnVsIDwtIHVzZWZ1bCAlPiUgbXV0YXRlKGxvY2F0aW9uID0gbWFwKGNvbXBsZXRlX2FkZHJlc3MsIGdlb2NvZGVfcGF1c2UpKQoKI3NhdmUgdG8gZGlzYywgdG8gYXZvaWQgYXZvaWQgdGhlIG5lZWQgdG8gZ2VvY29kZSB0aGVzZSBhZGRyZXNzZXMgYWdhaW4gd2hlbiB3ZSByZXJ1biB0aGUgYW5hbHlzaXMKd3JpdGVfcmRzKHVzZWZ1bCwgIi4vZGF0YS9ibGlnaHRfdmlvbGF0aW9uc19nZW9jb2Rlcy5yZHMiKQoKYGBgCgpUaGUgZ2VvY29kaW5nIGhhcyByZXR1cm5lZCBhIGRhdGEgZnJhbWUgZm9yIGVhY2ggb2YgdGhlIGFkZHJlc3Nlcy4gV2UgdGh1cyBuZWVkIHRvIHVucGFjayB0aGUgZWxlbWVudHMgb2YgdGhlIGxvY2F0aW9uIGNvbHVtbiwgZWFjaCBvZiB3aGljaCBpcyBhIGRhdGEgZnJhbWUuCgpgYGB7cn0KI3JlYWQgYmxpZ2h0X3Zpb2xhdGlvbnNfZ2VvY29kZXMgYXMgYSB0aWJibGUKYmxpZ2h0X3Zpb2xhdGlvbnNfZ2VvY29kZXMgPC0gcmVhZF9yZHMoIi4vZGF0YS9ibGlnaHRfdmlvbGF0aW9uc19nZW9jb2Rlcy5yZHMiKQoKI2Z1bmN0aW9uIGZvciByZW1vdmluZyB0aGUgaW5zdGFuY2VzIGZvciB3aGljaCBnZW9jb2RpbmcgZmFpbGVkIChmb3Igd2hpY2ggdGhlIHZhbHVlIGluIHRoZSBsb2NhdGlvbiBjb2x1bW4gaXMgTlVMTEwpLiBXZSB3aWxsIHVzZSB0aGlzIGZ1bmN0aW9uIGZvciBhbGwgb2YgdGhlIGdlb2NvZGVkIGRhdGEgZnJhbWVzLgpyZW1vdmVfbnVsbF9sb2NhdGlvbnMgPC0gZnVuY3Rpb24oZGYpIHsKICAjaWRlbnRpZnkgdGhlIHJvd3MgZm9yIHdoaWNoIHRoZSB2YWx1ZSBpbiB0aGUgbG9jYXRpb24gY29sdW1uIGlzIE5VTEwKICBudWxsX3Jvd3MgPC0gbGlzdCgpCiAgZm9yIChpbmRleCBpbiAxOm5yb3coZGYpKSB7CiAgICBpZiAoaXMubnVsbChkZiRsb2NhdGlvbltbaW5kZXhdXSkpIHsKICAgICAgbnVsbF9yb3dzIDwtIGMobnVsbF9yb3dzLCBpbmRleCkKICAgIH0KICB9CiAgI3JlbW92ZSB0aGUgcm93cyBmb3Igd2hpY2ggdGhlIHZhbHVlIG9mIHRoZSBsb2NhdGlvbiBjb2x1bW4gaXMgTlVMTAogIGRmIDwtIGRmWy1hcy5pbnRlZ2VyKG51bGxfcm93cyksXQp9CgpibGlnaHRfdmlvbGF0aW9uc19nZW9jb2RlcyA8LSByZW1vdmVfbnVsbF9sb2NhdGlvbnMoYmxpZ2h0X3Zpb2xhdGlvbnNfZ2VvY29kZXMpCgojV2l0aCBibGlnaHRfdmlvbGF0aW9uc19nZW9jb2RlcyBhIHRpYmJsZSwgd2UgY2FuIGFwcGx5IHRpZHlyOjp1bm5lc3QoKSwgd2hpY2ggd2lsbCBwbGFjZSB0aGUgbGF0aXR1ZGUgYW5kIGxvbmdpdHVkZSBpbiBjb2x1bW5zIGxhYmVsbGVkICJsYXQiIGFuZCAibG9uIi4KYmxpZ2h0X3Zpb2xhdGlvbnNfZ2VvY29kZXMgPC0gYmxpZ2h0X3Zpb2xhdGlvbnNfZ2VvY29kZXMgJT4lIHVubmVzdChsb2NhdGlvbikKCiNmaWxsIGluIHRoZSBgVmlvbGF0aW9uIExhdGl0dXRlYCBhbmQgYFZpb2xhdGlvbiBMb25naXR1ZGVgIGRhdGEgZnJhbWVzLCB3aGljaCBhbHJlYWQgZXhpc3QgaW4gdGhlIGJsaWdodF92aW9sYXRpb25zIGRhdGEgZnJhbWUKYmxpZ2h0X3Zpb2xhdGlvbnNfZ2VvY29kZXMgPC0gYmxpZ2h0X3Zpb2xhdGlvbnNfZ2VvY29kZXMgJT4lCiAgbXV0YXRlKGBWaW9sYXRpb24gTGF0aXR1ZGVgID0gbGF0LAogICAgICAgICBgVmlvbGF0aW9uIExvbmdpdHVkZWAgPSBsb24pCgojY3V0IG91dCBzb21lIGNvbHVtbnMgdGhhdCBoYXZlIGJlZW4gYWRkZWQKYmxpZ2h0X3Zpb2xhdGlvbnNfZ2VvY29kZXMgPC0gYmxpZ2h0X3Zpb2xhdGlvbnNfZ2VvY29kZXMgJT4lIAogIHNlbGVjdCgtZXh0cmFjdGVkX2xhdCwgLWV4dHJhY3RlZF9sb24sIC1jb21wbGV0ZV9hZGRyZXNzKQoKI3B1dCB0aGUgcG9zaXRpb24gaW5mb3JtYXRpb24gaW50byBhIHNpbXBsZSBmZWF0dXJlcyBmb3JtYXQgKHdoaWNoIHdpbGwgcmVtb3ZlIHRoZSAibGF0IiBhbmQgImxvbiIgY29sdW1ucykKYmxpZ2h0X3Zpb2xhdGlvbnNfZ2VvY29kZXNfc2YgPC0gc3RfYXNfc2YoYmxpZ2h0X3Zpb2xhdGlvbnNfZ2VvY29kZXMsIAogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICBjb29yZHMgPSBjKCJsb24iLCAibGF0IiksCiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIGNycyA9IDQzMjYpCgojY29tYmluZSB0aGUgcmVzdWx0cyB3aXRoIHRoZSBwcmV2aW91c2x5IGdlbmVyYXRlZCBzZiBkYXRhCmJsaWdodF92aW9sYXRpb25zX3NmIDwtIHJiaW5kKGJsaWdodF92aW9sYXRpb25zX3NwbGl0W1sxXV0sIGJsaWdodF92aW9sYXRpb25zX2dlb2NvZGVzX3NmKQoKcm0oYmxpZ2h0X3Zpb19uYSwgYmxpZ2h0X3Zpb2xhdGlvbnMsIGJsaWdodF92aW9sYXRpb25zX2dlb2NvZGVzLCAKICAgYmxpZ2h0X3Zpb2xhdGlvbnNfZ2VvY29kZXNfc2YsIGJsaWdodF92aW9sYXRpb25zX3NwbGl0LCB1c2VmdWwpCgpgYGAKCmBgYHtyfQoKI3RoZSBkaXNtYW50bGUgcGVybWl0cyBmb3Igd2hpY2ggcG9zaXRpb24gZGF0YSAobGF0aXR1ZGUgYW5kIGxvbmdpdHVkZSkgaXMgbWlzc2luZwpkaXNtYW50bGVfcGVybWl0c19zcGxpdF9uYSA8LSBkaXNtYW50bGVfcGVybWl0c19zcGxpdFtbMl1dCgojcmVtb3ZlIHRoZSBsYXN0IHR3byBjb2x1bW5zLCB3aGljaCB3ZXJlIG5vdCBjb250YWluZWQgaW4gdGhlIG9yaWdpbmFsIGRpc21hbnRsZV9wZXJtaXRzIGRhdGFzdGV0CmRpc21hbnRsZV9wZXJtaXRzX3NwbGl0X25hIDwtIGRpc21hbnRsZV9wZXJtaXRzX3NwbGl0X25hICU+JSAKICBzZWxlY3QoLWV4dHJhY3RlZF9sYXQsIC1leHRyYWN0ZWRfbG9uKQoKYGBgCgoKYGBge3IsIGV2YWwgPSBGQUxTRX0KCiNnZW9jb2RlIHRoZSBpdGVtcyBpbiBkaXNtYW50bGVfcGVybWl0c19zcGxpdF9uYSwgdXNpbmcgdGhlIGFkZHJlc3MgY29sdW1uIGFuZCB0aGUgZnVuY3Rpb24gZ2VvY29kZV9wYXVzZSwgd2hpY2ggbWFrZXMgYSBtYXhpbXVtIG9mIHNpeCBhdHRlbXB0cyBmb3IgZWFjaCBpdGVtLiBUaGUgcmVzdWx0IGlzIGxpc3Qgb2YgZGF0YWZyYW1lcyBpbiB0aGUgbG9jYXRpb24gY29sdW1uLgpkaXNtYW50bGVfcGVybWl0c19zcGxpdF9nZW9jb2RlIDwtIGRpc21hbnRsZV9wZXJtaXRzX3NwbGl0X25hICU+JQogIG11dGF0ZShsb2NhdGlvbiA9IG1hcChzdHJfYyhgU2l0ZSBBZGRyZXNzYCwgIiwgRGV0cm9pdCwgTWljaGlnYW4iKSwgZ2VvY29kZV9wYXVzZSkpCgojd3JpdGUgdGhlIHJlc3VsdHMgb2YgdGhlIGdlb2NvZGluZyB0byBkaXNrLCB0byBhdm9pZCBoYXZpbmcgdG8gcmVwZWF0IHRoZSBnZW9jb2Rpbmcgd2hlbiByZXJ1bm5pbmcgdGhlIGFuYWx5c2lzLgp3cml0ZV9yZHMoZGlzbWFudGxlX3Blcm1pdHNfc3BsaXRfZ2VvY29kZSwgIi4vZGF0YS9kaXNtYW50bGVfcGVybWl0c19nZW9jb2Rlcy5yZHMiKQoKcm0oZGlzbWFudGxlX3Blcm1pdHNfc3BsaXRfbmEpCgpgYGAKCgpgYGB7cn0KI2xvYWQgdGhlIGdlb2NvZGVkIGRhdGEgZnJhbWUgaW50byBSCmRpc21hbnRsZV9wZXJtaXRzX3NwbGl0X2dlb2NvZGUgPC0gcmVhZF9yZHMoIi4vZGF0YS9kaXNtYW50bGVfcGVybWl0c19nZW9jb2Rlcy5yZHMiKQoKI3VzZSB0aGUgcmVtb3ZlX251bGxfbG9jYXRpb25zKCkgdG8gcmVtb3ZlIHRoZSByb3dzIGZvciB3aGljaCBnZW9jb2RpbmcgZmFpbGVkIGFuZCB0aGVuIHBhcnNlIHRoZSBpbmZvcm1hdGlvbiAgaW4gdGhlIGRhdGFmcmFtZXMgaW4gdGhlIGxvY2F0aW9uIGNvbHVtbiBpbnRvIHR3byBuZXcgY29sdW1ucywgbGF0IGFuZCBsYW4KZGlzbWFudGxlX3Blcm1pdHNfc3BsaXRfZ2VvY29kZSA8LSAKICByZW1vdmVfbnVsbF9sb2NhdGlvbnMoZGlzbWFudGxlX3Blcm1pdHNfc3BsaXRfZ2VvY29kZSkgJT4lCiAgdW5uZXN0KGxvY2F0aW9uKQoKI2NvbnZlcnQgdG8gYSBzaW1wbGUgZmVhdHVyZXMgKHNmKSBkYXRhIGZyYW1lLCB1c2luZyB0aGUgbGF0aXRpdHVkZXMgYW5kIGxvbmdpdHVkZXMKZGlzbWFudGxlX3Blcm1pdHNfZ2VvY29kZV9zZiA8LSBzdF9hc19zZihkaXNtYW50bGVfcGVybWl0c19zcGxpdF9nZW9jb2RlLCAKICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgY29vcmRzID0gYygibG9uIiwgImxhdCIpLAogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICBjcnMgPSA0MzI2KQoKI2FwcGVuZCB0aGlzIHNpbXBsZSBmZWF0dXJlcyBkYXRhZnJhbWUgdG8gdGhlIGRhdGFmcmFtZSBmb3Igd2hpY2ggd2UgYWxyZWFkeSBoYWQgdXNhYmxlIHBvc2l0aW9ucwpkaXNtYW50bGVfcGVybWl0c19zZiA8LSByYmluZChkaXNtYW50bGVfcGVybWl0c19zcGxpdFtbMV1dLCBkaXNtYW50bGVfcGVybWl0c19nZW9jb2RlX3NmKQoKcm0oZGlzbWFudGxlX3Blcm1pdHNfc3BsaXRfZ2VvY29kZSwgZGlzbWFudGxlX3Blcm1pdHNfZ2VvY29kZV9zZiwgZGlzbWFudGxlX3Blcm1pdHMsIGRpc21hbnRsZV9wZXJtaXRzX3NwbGl0LCBkaXNtYW50bGVfcGVybWl0c19zcGxpdF9uYSkKCmBgYAoKV2Ugbm93IGZpbGwtaW4gdGhlIG1pc3NpbmcgcG9zaXRpb24gaW5mb3JtYXRpb24gZm9yIHRoZSBkYXRhc2V0IGZvciBjcmltZXMgdXAgdG8gMTItMDYtMjAxNgoKYGBge3J9CgojcmV0dXJuIHRvIHRoZSBvbGRlciBjcmltZSBkYXRhCmNyaW1lX3RvXzEyMDYyMDE2X2xlZnRvdmVycyA8LSBjcmltZV90b18xMjA2MjAxNl9zcGxpdFtbMl1dCgojY3V0IG91dCB0aGUgYWRkcmVzc2VzIHRoYXQgYmVnaW4gd2l0aCAiMDAiCmNyaW1lX3RvXzEyMDYyMDE2X2xlZnRvdmVycyA8LSBjcmltZV90b18xMjA2MjAxNl9sZWZ0b3ZlcnMgJT4lIAogIGZpbHRlcihzdHJfc3ViKExPQ0FUSU9OLCAxLCAyKSAhPSAiMDAiKQoKI2ZpbHRlciBvdXQgc29tZSBvYnZpb3VzbHkgdXNlbGVzcyBhZGRyZXNzZXMsIHdpdGggZmV3IGNoYXJhY3RlcnMgYmVmb3JlIHRoZSBmaXJzdCAiKCIKY3JpbWVfdG9fMTIwNjIwMTZfbGVmdG92ZXJzIDwtIGNyaW1lX3RvXzEyMDYyMDE2X2xlZnRvdmVycyAlPiUgCiAgZmlsdGVyKCFzdHJfbG9jYXRlKExPQ0FUSU9OLCAiXFwoIilbLDFdICVpbiUgMToxMykKCiNyZW1vdmUgdGhlIHR3byBjb2x1bW5zIHRoYXQgd2VyZSBhZGRlZCBlYXJsaWVyCmNyaW1lX3RvXzEyMDYyMDE2X2xlZnRvdmVycyA8LSBjcmltZV90b18xMjA2MjAxNl9sZWZ0b3ZlcnMgJT4lIAogIHNlbGVjdCgtZXh0cmFjdGVkX2xhdCwgLWV4dHJhY3RlZF9sb24pCgojY3JlYXRlIGEgY29sdW1uIGZvciB1c2UgaW4gZ2VvY29kaW5nCmNyaW1lX3RvXzEyMDYyMDE2X2xlZnRvdmVycyA8LSBjcmltZV90b18xMjA2MjAxNl9sZWZ0b3ZlcnMgJT4lIAogIG11dGF0ZShleHRyYWN0ZWRfYWRkcmVzcyA9IHN0cl9jKHN0cl9zdWIoTE9DQVRJT04sIDEsIAogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgc3RyX2xvY2F0ZShMT0NBVElPTiwgIlxcKCIpWywxXSAtIDIpLAogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAiLCBEZXRyb2l0LCBNaWNoaWdhbiIpKQoKYGBgCgpgYGB7ciwgZXZhbCA9IEZBTFNFfQoKI2dlb2NvZGUgdGhlIGVsZW1lbnRzIG9mIGV4dHJhY3RlZF9hZGRyZXNzLCB1c2luZyB0aGUgZnVuY3Rpb24gZ2VvY29kZV9wYXVzZQpjcmltZV90b18xMjA2MjAxNl9sZWZ0b3ZlcnNfZ2VvY29kZSA8LSBjcmltZV90b18xMjA2MjAxNl9sZWZ0b3ZlcnMgJT4lIAogIG11dGF0ZShsb2NhdGlvbiA9IG1hcChleHRyYWN0ZWRfYWRkcmVzcywgZ2VvY29kZV9wYXVzZSkpCgojc2F2ZSB0aGUgcmVzdWx0cywgdG8gYXZvaWQgaGF2aW5nIHRvIGdlb2NvZGUgYWdhaW4gd2hlbiByZXJ1bm5pbmcgdGhlIGFuYWx5c2lzCndyaXRlX3JkcyhjcmltZV90b18xMjA2MjAxNl9sZWZ0b3ZlcnNfZ2VvY29kZSwgIi4vZGF0YS9jcmltZV90b18xMjA2MjAxNl9sZWZ0b3ZlcnNfZ2VvY29kZS5yZHMiKQoKYGBgCgoKCmBgYHtyfQoKY3JpbWVfdG9fMTIwNjIwMTZfbGVmdG92ZXJzX2dlb2NvZGUgPC0gcmVhZF9yZHMoIi4vZGF0YS9jcmltZV90b18xMjA2MjAxNl9sZWZ0b3ZlcnNfZ2VvY29kZS5yZHMiKQoKI2N1dCBvdXQgdGhlIGNvbHVtbiB3ZSB1c2VkIGZvciBnZW9jb2RpbmcKY3JpbWVfdG9fMTIwNjIwMTZfbGVmdG92ZXJzX2dlb2NvZGUgPC0gCiAgY3JpbWVfdG9fMTIwNjIwMTZfbGVmdG92ZXJzX2dlb2NvZGUgJT4lIHNlbGVjdCgtZXh0cmFjdGVkX2FkZHJlc3MpCiAgCiNjdXQgb3V0IG9mIHRoZSBnZW9jb2RlIGZhaWx1cmVzIGFuZCBwdXQgdGhlIGxvY2F0aW9uIGluZm9ybWF0aW9uIGludG8gdGhlIGNvbHVtbnMgbGF0IGFuZCBsb24KY3JpbWVfdG9fMTIwNjIwMTZfbGVmdG92ZXJzX2dlb2NvZGUgPC0gCiAgcmVtb3ZlX251bGxfbG9jYXRpb25zKGNyaW1lX3RvXzEyMDYyMDE2X2xlZnRvdmVyc19nZW9jb2RlKSAlPiUKICB1bm5lc3QobG9jYXRpb24pCgojY3JlYXRlIGEgc2ltcGxlIGZlYXR1cmVzIChzZikgb2JqZWN0LCB1c2luZyB0aGUgbGF0aXRpdHVkZXMgYW5kIGxvbmdpdHVkZXMKY3JpbWVfdG9fMTIwNjIwMTZfbGVmdG92ZXJzX3NmIDwtIHN0X2FzX3NmKGNyaW1lX3RvXzEyMDYyMDE2X2xlZnRvdmVyc19nZW9jb2RlLCAKICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgY29vcmRzID0gYygibG9uIiwgImxhdCIpLAogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICBjcnMgPSA0MzI2KQoKI2FwcGVuZCB0aGlzIHNpbXBsZSBmZWF0dXJlcyBkYXRhZnJhbWUgdG8gdGhlIGRhdGFmcmFtZSBmb3Igd2hpY2ggd2UgYWxyZWFkeSBoYWQgbG9jYXRpb25zCmNyaW1lX3RvXzEyMDYyMDE2X3NmIDwtIHJiaW5kKGNyaW1lX3RvXzEyMDYyMDE2X3NwbGl0W1sxXV0sIGNyaW1lX3RvXzEyMDYyMDE2X2xlZnRvdmVyc19zZikKCnJtKGNyaW1lX3RvXzEyMDYyMDE2LCBjcmltZV90b18xMjA2MjAxNl9sZWZ0b3ZlcnNfZ2VvY29kZSwgY3JpbWVfdG9fMTIwNjIwMTZfbGVmdG92ZXJzX3NmLCBjcmltZV90b18xMjA2MjAxNl9sZWZ0b3ZlcnMsIGNyaW1lX3RvXzEyMDYyMDE2X3NwbGl0KQoKYGBgCgoKYGBge3J9CgojY29uc2lkZXIgdGhlIGV4YW1wbGVzIGluIHRoZSByZWNlbnQgY3JpbWUgZGF0YSBmb3Igd2hpY2ggdGhlIGNvbnZlcnNpb24gdG8gc2YgZGlkbid0IHdvcmssIHJlbW92ZSB0aGUgdHdvIGNvbHVtbnMgdGhhdCB3ZSBoYXZlIGFkZGVkLCBhbmQgY3JlYXRlIGFuZCBhZGRyZXNzIGNvbHVtbiBmb3IgZ2VvY29kaW5nCmNyaW1lXzEyMDYyMDE2X3RvXzAzMTkyMDE4X2xlZnRvdmVycyA8LSBjcmltZV8xMjA2MjAxNl90b18wMzE5MjAxOF9zcGxpdFtbMl1dICU+JQogIHNlbGVjdCgtZXh0cmFjdGVkX2xhdCwgLWV4dHJhY3RlZF9sb24pICU+JQogIG11dGF0ZShleHRyYWN0ZWRfYWRkcmVzcyA9IHN0cl9jKGBJbmNpZGVudCBBZGRyZXNzYCwgIiwgRGV0cm9pdCwgTWljaGlnYW4iKSkKCmBgYAoKYGBge3IsIGV2YWwgPSBGQUxTRX0KCmNyaW1lXzEyMDYyMDE2X3RvXzAzMTkyMDE4X2dlb2NvZGUgPC0gY3JpbWVfMTIwNjIwMTZfdG9fMDMxOTIwMThfbGVmdG92ZXJzICU+JSAKICBtdXRhdGUobG9jYXRpb24gPSBtYXAoZXh0cmFjdGVkX2FkZHJlc3MsIGdlb2NvZGVfcGF1c2UpKQoKd3JpdGVfcmRzKGNyaW1lXzEyMDYyMDE2X3RvXzAzMTkyMDE4X2dlb2NvZGUsICIuL2RhdGEvY3JpbWVfMTIwNjIwMTZfdG9fMDMxOTIwMThfZ2VvY29kZS5yZHMiKQoKYGBgCgpgYGB7cn0KCmNyaW1lXzEyMDYyMDE2X3RvXzAzMTkyMDE4X2dlb2NvZGUgPC0gcmVhZF9yZHMoIi4vZGF0YS9jcmltZV8xMjA2MjAxNl90b18wMzE5MjAxOF9nZW9jb2RlLnJkcyIpICU+JQogIHNlbGVjdCgtZXh0cmFjdGVkX2FkZHJlc3MpCgojcmVtb3ZlIHRoZSByb3dzIGZvciB3aGljaCB0aGUgdmFsdWUgb2YgbG9jYXRpb24gaXMgTlVMTCBhbmQgdGhlbiB1bm5lc3QgdGhlIHJlbWFpbmluZyBsb2NhdGlvbnMKY3JpbWVfMTIwNjIwMTZfdG9fMDMxOTIwMThfZ2VvY29kZSA8LSAKICByZW1vdmVfbnVsbF9sb2NhdGlvbnMoY3JpbWVfMTIwNjIwMTZfdG9fMDMxOTIwMThfZ2VvY29kZSkgJT4lCiAgdW5uZXN0KGxvY2F0aW9uKQoKI2NvbnZlcnQgdGhlIGRhdGFmcmFtZSB0byBhIHNpbXBsZSBmZWF0dXJlcyBzZXQKY3JpbWVfMTIwNjIwMTZfdG9fMDMxOTIwMThfc2YgPC0gc3RfYXNfc2YoY3JpbWVfMTIwNjIwMTZfdG9fMDMxOTIwMThfZ2VvY29kZSwgCiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIGNvb3JkcyA9IGMoImxvbiIsICJsYXQiKSwKICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgY3JzID0gNDMyNikgIAoKI2NvbWJpbmUgdGhlIGdlb2NvZGVkIGRhdGEgd2l0aCB0aGUgc2YgZGF0YWZyYW1lIGNyZWF0ZWQgZWFybGllcgpjcmltZV8xMjA2MjAxNl90b18wMzE5MjAxOCA8LSByYmluZChjcmltZV8xMjA2MjAxNl90b18wMzE5MjAxOF9zcGxpdFtbMV1dLCBjcmltZV8xMjA2MjAxNl90b18wMzE5MjAxOF9zZikKCnJtKGNyaW1lXzEyMDYyMDE2X3RvXzAzMTkyMDE4X3NwbGl0LCBjcmltZV8xMjA2MjAxNl90b18wMzE5MjAxOF9nZW9jb2RlLCBjcmltZV8xMjA2MjAxNl90b18wMzE5MjAxOF9sZWZ0b3ZlcnMsIGNyaW1lXzEyMDYyMDE2X3RvXzAzMTkyMDE4X3NmKQoKYGBgCgpgYGB7cn0KCiNnZW9jb2RlIHRoZSBvbmUgaXRlbSBpbiB0aGUgSW1wcm92ZSBEZXRyb2l0IElzc3VlcyBkYXRhIGZvciB3aGljaCB0aGUgZ2l2ZW4gY29vcmRpbmF0ZXMgd2VyZSBvYnZpb3VzbHkgaW5jb3JyZWN0LCBhbmQgdGhlbiBjb252ZXJ0IHRvIGFuIHNmIG9iamVjdC4gSWYgZ2VvY29kaW5nIGZhaWxzLCBydW4gdGhpcyBiaXQgYWdhaW4KaW1wcm92ZV9kZXRyb2l0X2lzc3Vlc19sZWZ0b3Zlcl9zZiA8LSBpbXByb3ZlX2RldHJvaXRfaXNzdWVzX3NwbGl0W1syXV0gJT4lCiAgc2VsZWN0KC1leHRyYWN0ZWRfbGF0LCAtZXh0cmFjdGVkX2xvbikgJT4lCiAgbXV0YXRlKGxvY2F0aW9uID0gbWFwKEFkZHJlc3MsIGdlb2NvZGVfcGF1c2UpKSAlPiUKICB1bm5lc3QobG9jYXRpb24pICU+JSAKICBzdF9hc19zZihjb29yZHMgPSBjKCJsb24iLCAibGF0IiksIGNycyA9IDQzMjYpICAKCiNzcGxpY2Ugd2l0aCB0aGUgcHJldmlvdXNseSBnZW5lcmF0ZWQgc2YgZGF0YWZyYW1lCmltcHJvdmVfZGV0cm9pdF9pc3N1ZXMgPC0gcmJpbmQoaW1wcm92ZV9kZXRyb2l0X2lzc3Vlc19zcGxpdFtbMV1dLCBpbXByb3ZlX2RldHJvaXRfaXNzdWVzX2xlZnRvdmVyX3NmKQoKcm0oaW1wcm92ZV9kZXRyb2l0X2lzc3Vlc19zcGxpdCwgaW1wcm92ZV9kZXRyb2l0X2lzc3Vlc19sZWZ0b3Zlcl9zZikKCmBgYAoKV2UgYmVnaW4gdGhlIGFzc2lnbm1lbnQgb2YgbGFiZWxzIHRvIHRoZSBidWlkaW5nczogYmxpZ2h0ZWQgb3Igbm90IGJsaWdodGVkLiBCdWlsZGluZ3Mgd2lsbCBiZSByZXByZXNlbnRlZCBieSBwYXJjZWxzIHRoYXQgaGF2ZSBvciBoYXZlIGhhZCBidWlsZGluZ3Mgb24gdGhlbSwgd2hldGhlciBieSBiZWluZyBzbyByZXByZXNlbnRlZCBhcyBpbiB0aGUgYHBhcmNlbHNfc2ZgIGRhdGEgZnJhbWUgYXMgaW5jbHVkaW5nIHN0cnVjdHVyZXMgb3IgaW4gdGhlIGRpc21hbnRsZSBwZXJtaXRzIGRhdGFmcmFtZSBhcyBoYXZpbmcgaGFkIGEgZGlzbWFudGUgcGVybWl0IGFzc29jaWF0ZWQgd2l0aCBpdCwgdGh1cyBzdWdnZXN0aW5nIHRoYXQgdGhlcmUgKndhcyogYSBidWlsZGluZyBvbiB0aGUgcGFyY2VsLiAKCldlIHdpbGwgdXNlIHBhcmNlbCBudW1iZXJzIHRvIHJlZmVyIHRvIHRoZSBwYXJjZWxzLiBUaGlzIHdvcmtzIGJlY2F1c2UgcGFyY2VsbnVtIGNvbHVtbiBjb250YWlucyBubyByZXBlYXRzIG92ZXIgZGlmZmVyZW50IHJvd3MgKHNlZSBiZWxvdywgaW4gd2hpY2ggYGR1cGxpY2F0ZV9wYXJjZWxfbnVtYmVyc19pbl9wYXJjZWxfZGF0YWAgaGFzIHplcm8gcm93cykuIAoKYGBge3J9CiNBcyBwZXIgYWJvdmUsIGZvbGxvd2luZyByZXR1cm5zIGFuIGVtcHR5IGRhdGEgZnJhbWUKZHVwbGljYXRlX3BhcmNlbF9udW1iZXJzX2luX3BhcmNlbF9kYXRhIDwtIAogIHBhcmNlbF9zZiAlPiUKICBncm91cF9ieShwYXJjZWxudW0pICU+JSAKICBtdXRhdGUobiA9IG4oKSkgJT4lCiAgdW5ncm91cCgpICU+JSAKICBmaWx0ZXIobiA+IDEpCmR1cGxpY2F0ZV9wYXJjZWxfbnVtYmVyc19pbl9wYXJjZWxfZGF0YQpybShkdXBsaWNhdGVfcGFyY2VsX251bWJlcnNfaW5fcGFyY2VsX2RhdGEpCmBgYApUaGUgZGlzbWFudGxlIHBlcm1pdHMgZGF0YSwgaG93ZXZlciwgbWF5IHNlZW0gbGVzcyBjbGVhbiB0aGFuIHRoZSBwYXJjZWxfc2YsIGFzIGl0IGNvbnRhaW5zIHJlcGV0aXRpb25zIG9mIHRoZSBwYXJjZWwgbnVtYmVycyB0aGF0IGNvcnJlc3BvbmQgdG8gZGlmZmVyZW50IGFkZHJlc3NlcyB0aGF0IHdvdWxkIHJlZmVyLCBpbiBzb21lIGNhc2VzLCB0byBkaXN0aW5jdCBsb2NhdGlvbnMuIChJdCBhbHNvIGluZGljYXRlcyB0aGF0IGEgZmV3IGluZGl2aWR1YWwgbG9jYXRhdGlvbnMsIGlkZW50aWZpZWQgd2l0aCBhZGRyZXNzZXMsIGhhZCBtb3JlIHRoYW4gb25lIGFzc29jaWF0ZWQgZGlzbWFudGxlIHBlcm1pdC4gVGhpcyBuZWVkIG5vdCBiZSBwcm9ibGVtYXRpYy0tLWEgcGVybWl0IGNvdWxkIGV4cGlyZSBiZWZvcmUgdGhlIHdvcmsgaXMgY2FycmllZCBvdXQsIG9yIHRoZXJlIGNvdWxkIGJlIG1vcmUgdGhhbiBvbmUgc3RydWN0dXJlIG9uIGEgcGFyY2VsLikgIFRoZXNlIHJlcGV0aXRpb25zIGFyZSBpbiBgZHVwbGljYXRlX3BhcmNlbF9udW1iZXJzX292ZXJfZGlzdGluY3RfYWRkcmVzc2VzYCwgd2hpY2ggY29udGFpbnMgMjYwIHJvd3MuIEkgc2hvdWxkIGFsc28gbm90ZSB0aGF0LCBpbiAgbW9zdCBvZiB0aGVzZSBjYXNlcyB3aXRoIGR1cGxpY2F0ZSBwYXJjZWwgbnVtYmVycyAoYW5kIGFkZHJlc3NlcyBpbmRpY2F0aW5nIGRpZmZlcmVudCBsb2NhdGlvbnMpLCB0aGUgcmVjb3JkZWQgbGF0aXR1ZGUgYW5kIGxvbmdpdHVkZSBhcmUgaWRlbnRpY2FsLiBXZSBjYW4gdGh1cyBpbmZlciB0aGF0IHNvbWUgb2YgdGhpcyBsb2NhdGlvbiBpbmZvcm1hdGlvbiBpcyBpbmNvcnJlY3QuCmBgYHtyfQpkdXBfcGFyX251bV9pbl9kaXNtYW50bGVfZGF0YSA8LQogIGRpc21hbnRsZV9wZXJtaXRzX3NmICU+JQogIGdyb3VwX2J5KGBQYXJjZWwgTnVtYmVyYCkgJT4lIAogIG11dGF0ZShuID0gbigpKSAlPiUKICB1bmdyb3VwKCkgJT4lIAogIGZpbHRlcihuID4gMSkgJT4lCiAgc2VsZWN0KGBQYXJjZWwgTnVtYmVyYCwgYFNpdGUgQWRkcmVzc2ApCmFzLmRhdGEuZnJhbWUoZHVwX3Bhcl9udW1faW5fZGlzbWFudGxlX2RhdGEpCnJtKGR1cF9wYXJfbnVtX2luX2Rpc21hbnRsZV9kYXRhKQoKI3BhcmNlbCBudW1iZXJzIGluIHRoZSBkaXNtYW50bGUgcGVybWl0cyBkYXRhIHRoYXQgYXJlIGRpc3RyaWJ1dGVkIG92ZXIgZGlzaW5jdCBhZGRyZXNzZXNlcwpkdXBfcGFyX251bV9vdmVyX2Rpc3RpbmN0X2FkZHJlc3NlcyA8LSAKICBkaXNtYW50bGVfcGVybWl0c19zZiAlPiUKICBncm91cF9ieShgUGFyY2VsIE51bWJlcmApICU+JQogIG11dGF0ZShwYXJjZWxfbnVtYmVyX29jY3VyYW5jZXMgPSBuKCkpICU+JQogIHVuZ3JvdXAoKSAlPiUKICBmaWx0ZXIocGFyY2VsX251bWJlcl9vY2N1cmFuY2VzID4gMSkgJT4lCiAgc2VsZWN0KGBQYXJjZWwgTnVtYmVyYCwgYFNpdGUgQWRkcmVzc2AsIHBhcmNlbF9udW1iZXJfb2NjdXJhbmNlcykgJT4lCiAgZ3JvdXBfYnkoYFBhcmNlbCBOdW1iZXJgLCBgU2l0ZSBBZGRyZXNzYCkgJT4lCiAgbXV0YXRlKG0gPSBuKCkpICU+JQogIGZpbHRlcihtIDwgcGFyY2VsX251bWJlcl9vY2N1cmFuY2VzKSAlPiUKICBhcnJhbmdlKGBQYXJjZWwgTnVtYmVyYCkKYXMuZGF0YS5mcmFtZShkdXBfcGFyX251bV9vdmVyX2Rpc3RpbmN0X2FkZHJlc3NlcykKcm0oZHVwX3Bhcl9udW1fb3Zlcl9kaXN0aW5jdF9hZGRyZXNzZXMpCgpgYGAKU29tZSBvZiByZXBlYXRzIG9mIHRoZSBwYXJjZWwgbnVtYmVycyB3b3VsZCBzZWVtIHRvIGNvcnJlc3BvbmQgdG8gdGhlIHNvbWUgbG9jYXRpb24gKHdpdGggdGhlIGFkZHJlc3NlcyByZWNvcmRlZCBzb21ld2hhdCBkaWZmZXJlbnRseSksIHdoaWxlIG90aGVycyB3b3VsZCBub3QuIFRoZSBudW1iZXJzIHJvd3MgaW4gcXVlc3Rpb24gaXMgcmVsYXRpdmVseSBzbWFsbCAoMjcyKSwgc28gSSB3aWxsIGlnbm9yZSB0aGUgaXNzdWUgZm9yIG5vdy4gKEkgd2lsbCBldmVudHVhbGx5IGVpdGhlciByZW1vdmUgdGhpcyBkYXRhIGFyZSBhdHRlbXB0IHRvIGF0dGFjaGUgdGhlIGNvcnJlY3QgbG9jYXRpb24gaW5mb3JtYXRpb24uKQoKYGBge3IsIGV2YWwgPSBGQUxTRX0KI25vdGUgdGhhdCB0aGUgZm9sbG93aW5nIHJlbW92ZXMgcm93cyB3aXRoIGR1cGxpY2F0ZSBwYXJjZWxzCiNkdXBsaWNhdGVfcGFyY2VsX251bWJlcnMgJT4lIGRpc3RpbmN0KHBhcmNlbG51bSwgLmtlZXBfYWxsID0gVFJVRSkKCnBhcmNlbF9qb2luX3NmX3BhcmNlbF9maXJzdCA8LSAKICBmdWxsX2pvaW4ocGFyY2VsX3NmICU+JSBzZWxlY3QocGFyY2VsbnVtKSwKICAgICAgICAgICAgZGlzbWFudGxlX3Blcm1pdHNfc2YgJT4lIGFzLmRhdGEuZnJhbWUoKSAlPiUgc2VsZWN0KGBQYXJjZWwgTnVtYmVyYCksCiAgICAgICAgICAgIGMoInBhcmNlbG51bSIgPSAiUGFyY2VsIE51bWJlciIpKSAlPiUKICBhcnJhbmdlKGBQYXJjZWwgTnVtYmVyYCkKCnBhcmNlbF9qb2luX3NmX2Rpc21hbnRsZV9maXJzdCA8LQogIGZ1bGxfam9pbihkaXNtYW50bGVfcGVybWl0c19zZiAlPiUgc2VsZWN0KGBQYXJjZWwgTnVtYmVyYCksIAogICAgICAgICAgICBwYXJjZWxfc2YgJT4lIGFzLmRhdGEuZnJhbWUoKSAlPiUgc2VsZWN0KHBhcmNlbG51bSksCiAgICAgICAgICAgIGMoIlBhcmNlbCBOdW1iZXIiID0gInBhcmNlbG51bSIpKSAlPiUKICBhcnJhbmdlKGBQYXJjZWwgTnVtYmVyYCkKCnN0X2NycyhwYXJjZWxfc2YpCnN0X2NycyhkaXNtYW50bGVfcGVybWl0c19zZikKCiNCb3RoIG9mIHRoZXNlIHlpZWxkIGFuIEVQU0cgb2YgNDMyNi4gTmV0aGVyZWxlc3MsIHRoZSBmb2xsb3cgc3RlcCBzZWVtcyBuZWNlc3NhcnkuCgpzdF9jcnMoZGlzbWFudGxlX3Blcm1pdHNfc2YpIDwtIHN0X2NycyhwYXJjZWxfc2YpCgp0ZW1wIDwtIHN0X2pvaW4oZGlzbWFudGxlX3Blcm1pdHNfc2YsIHBhcmNlbF9zZiwgam9pbiA9IHN0X3dpdGhpbikKICAKdGVtcDIgPC0gdGVtcCAlPiUgZmlsdGVyKGBQYXJjZWwgTnVtYmVyYCAhPSBwYXJjZWxudW0pCgp0ZW1wMiA8LSB0ZW1wMiAlPiUgc2VsZWN0KGBQYXJjZWwgTnVtYmVyYCwgcGFyY2VsbnVtLCBgU2l0ZSBBZGRyZXNzYCwgYWRkcmVzcykKCgojbm90ZSB0aGF0IG9iamVjdGlkIGluIHBhcmNlbF9zZiBoYXMgbm8gTkEgdmFsdWVzLCBhbmQgdGhhdCBvYmplY3RpZCBpcyBhIGtleSBpbiBwYXJjZWxfc2YKcGFyY2VsX3NmICU+JSBhcy5kYXRhLmZyYW1lKCkgJT4lIGZpbHRlcihpcy5uYShvYmplY3RpZCkpCnBhcmNlbF9zZiAlPiUgY291bnQob2JqZWN0aWQpICU+JSBmaWx0ZXIobiA+IDEpCgojbm90ZSB0aGF0IGBQZXJtaXQgTnVtYmVyYCBpcyBhIGFsc28gYSBrZXksIGZvciBkaXNtYW50bGVfcGVybWl0c19zZgpkaXNtYW50bGVfcGVybWl0c19zZiAlPiUgYXMuZGF0YS5mcmFtZSgpICU+JSBmaWx0ZXIoaXMubmEoYFBlcm1pdCBOdW1iZXJgKSkKZGlzbWFudGxlX3Blcm1pdHNfc2YgJT4lIGNvdW50KGBQZXJtaXQgTnVtYmVyYCkgJT4lIGZpbHRlcihuID4gMSkKCiN3aXRoIHRoZSBhYm92ZSBpbiBtaW5kLCB3ZSBleGFtaW5lIHRoZSBOQSB2YWx1ZXMgZm9yIHRoZXNlIGNvbHVtbnMgaW4gb3VyIGZ1bGwgam9pbiwgYmVnaW5uaW5nIHdpdGggb2JqZWN0aWQgaW4gcGFyY2VsX3NmLiBUaGUgaWRlYSBpcyB0aGF0IGFueSBOQSB2YWx1ZSBmb3Igb2JqZWN0aWQgaW4gcGFyY2VsX2pvaW4gd291bGQgY29ycmVzcG9uZCB0byBhIHBhcmNlbCBpbiB0aGUgZGlzbWFudGxlIHBlcm1pdHMgZGF0YXNldCB0aGF0IGlzIGVpdGhlciBub3QgcmVmbGVjdGVkIGluIHRoZSBwYXJjZWxzIGRhdGFzZXQgb3IgZm9yIHdoaWNoIHRoZXJlIGlzIGEgZmxhdyBpbiB0aGUgZGF0YS4KcGFyY2VsX2pvaW4gJT4lIGZpbHRlcihpcy5uYShvYmplY3RpZCkpCgpkaXNtYW50bGVfcGVybWl0c19zZiAlPiUgZmlsdGVyKGBQYXJjZWwgTnVtYmVyYCA9PSAiMjIxMDg1MTIuIikKCiNkaXNtYW50bGVkX3N0cnVjdHVyZXMgPC0gaW5pdGlhbF9qb2luICU+JSBmaWx0ZXIoIWlzLm5hKGBQZXJtaXQgTnVtYmVyYCkpCgpwYXJjZWxfc2YgJT4lIGZpbHRlcihwYXJjZWxudW0gPT0gIjIyMTA4NTEyLiIpCgpwYXJjZWxfdG1wIDwtIGJsaWdodF92aW9sYXRpb25zX3NmW2MoMSwgMiksXQoKc3RfZGlzdGFuY2UocGFyY2VsX3RtcCkKCm1fbGlzdCA8LSBtYXBwbHkoc3RfZGlzdGFuY2UsIGJsaWdodF92aW9sYXRpb25zX3NmJGdlb21ldHJ5WzFdLCBmcmVkJGdlb21ldHJ5KQoKZGlzbWFudGxlX3Blcm1pdHNfc2YgJT4lIGFzLmRhdGEuZnJhbWUoKSAlPiUgZmlsdGVyKGlzLm5hKGBQYXJjZWwgTnVtYmVyYCkpCgp0ZW1wNCA8LSBzdF9kaXN0YW5jZShwYXJjZWxfc2ZbMTk1MDk5LF0sIAogICAgICAgICAgICBibGlnaHRfdmlvbGF0aW9uc19zZlsyMjIzMzoyMjI1NSxdKQoKc3RfY3JzKGJsaWdodF92aW9sYXRpb25zX3NmKSA8LSBzdF9jcnMocGFyY2VsX3NmKQoKcGxvdChibGlnaHRfdmlvbGF0aW9uc19zZiwgbWF4LnBsb3QgPSAxKQoKYGBgCgpNYXBzOgoKYGBge3IsIGV2YWwgPSBGQUxTRX0KbGlicmFyeShnZ21hcCkKCmdncGxvdChibGlnaHRfdmlvbGF0aW9uc19zZiAlPiUgc2VsZWN0KGdlb21ldHJ5KSkgKwogIGdlb21fc2YoKSArIAogIGdlb21fZGVuc2l0eTJkKGRhdGEgPSBibGlnaHRfdmlvbGF0aW9uc19zZiAlPiUgc2VsZWN0KGdlb21ldHJ5KSkKCgpnZ3Bsb3QoZGF0YT14eS5zZikgKwogICAgZ2VvbV9zZigpICsKICAgIGdlb21fZGVuc2l0eTJkKGRhdGE9eHkuc2YsIGFlcyh4PXgseT15LGNvbG91cj0uLmxldmVsLi4pKQoKCmRldHJvaXRfZ2cgPC0gZ2V0X21hcCgiRGV0cm9pdCIsIG1hcHR5cGUgPSAidG9uZXItbGl0ZSIsCiAgICAgICAgICAgICAgICAgICAgICB6b29tID0gMTEpCgpnZ21hcChkZXRyb2l0X2dnKQpgYGAKCgoKCgoK